View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default Nested functions in conditional formatting formulae

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.