Forum Discussion
Conditional formatting on row based on text result from formula from another cell
I am trying to format the cells in a row between columns F-T based on the result of "Yes" from column U containing the IF formula =IF(J2=M2,"Yes","No"). When I apply the conditional form...
Hi Riny
You beat me to it! I do so hate the concept of relative referencing; it is an unnecessary mess.
Maybe it is an act of heresy to say so on a spreadsheet forum though 😮!
Peter
