Nested functions in conditional formatting formulae

J

Joseph

I am trying to format a range of cells as a function of cell value compared
with other cells. My attempts have failed so far. For e.g.:
=OR(ADDRESS(ROW(),COLUMN())=$B$18,ADDRESS(ROW(),COLUMN())=$B$17)
=OR(INDIRECT(CONCATENATE("R",(ROW()+1),"C",COLUMN()),FALSE)=B17)
I do not wish to write VB code.
Thanks in advance for any ideas.
 
P

Peo Sjoblom

Maybe you could post what you are trying to achive
it's hard to guess what you are trying to do
 
J

Joseph

The objective is determine, for e.g., the backgraound colour of cells in an
array, as a function of their content. The specific case in this exercise is
the DoReMi musical staff (set of lines).

The content of every cell is compared with a pair of cells, and in the
background colour is modified if the OR() returns a TRUE value.
 
J

Joseph

Found a solution:
=OR(CELL("contents",INDIRECT(ADDRESS(ROW(),3)))=$B$17,CELL("contents",INDIRECT(ADDRESS(ROW(),3)))=$B$18)

Where $B$17 and $B$18 contain the values Do and Ti. The funtion
CELL("contents",INDIRECT(ADDRESS(ROW(),3))) resolves to the value in the 3rd
column on the current row, which has the modified solfege resulting from the
musical key. if that value equals Do or Ti, the background colour of the cell
is modified, thus giving the student a visual image of the note distances.

Regards,
Joseph
 
Top