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

"Peo Sjoblom" wrote:

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


--

Regards,

Peo Sjoblom


"Joseph" wrote in message
...
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(),CO LUMN())=$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.