Hi all.
Could anyone please help with highlighting adjacent cells if they contain data.
I have tried conditional formatting, but have had no luck.
What I am trying to achieve is if there is data in columns B & C, for the row to turn to yellow.
If only in column B, then turn to blue
If only in column C, turn to orange.
Thanks for looking.
Regards,
Graham
Could anyone please help with highlighting adjacent cells if they contain data.
I have tried conditional formatting, but have had no luck.
What I am trying to achieve is if there is data in columns B & C, for the row to turn to yellow.
If only in column B, then turn to blue
If only in column C, turn to orange.
Thanks for looking.
Regards,
Graham