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.