Forum Discussion
Solved
Help with Conditional formatting
I am trying to highlight A2 in pink when E2 or F2 are blank. How can I achieve this? I've tried a number of ways to create the formula but none are working for me so need your expert advise. :) Thank...
Hi Sarah,
You don't need to IF function just use OR function as below syntax:
=OR($E$2="",$F$2="")
This is because the Conditional Formatting rule only needs a boolean value (TRUE/FALSE).
Hope that helps
Hi Sarah,
You don't need to IF function just use OR function as below syntax:
=OR($E$2="",$F$2="")
This is because the Conditional Formatting rule only needs a boolean value (TRUE/FALSE).
Hope that helps
It worked!! Thank you for keeping me sane, lol. I needed that!