Forum Discussion
Conditionally formatting text
Hi experts,
I want to conditionally format the contents of the cells in one column based on it if mates the contents of the cell in the column next to it.
There is an order number in the first co...
Hi Hayley,
You may apply two rules to your column B, for the green
=ISNUMBER(SEARCH($B3,$A3))
and for the red
=NOT(ISNUMBER(SEARCH($B3,$A3)))
Just be careful with absolute and relative references.
Attached.
Thank-you Sergei, that's worked wonderfully