Forum Discussion
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. :) Thanks in advance.
The last formula I tried was: ="IF($E$2="" OR $F$2="")"
I've added a screenshot as well so you can see that A2 has alpha numerics in it and that does not matter to me in this scenario.
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
2 Replies
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!
