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.

"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.