Help with Conditional formatting

[Sarah Prouty]

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.

[#2 · Accepted solution]

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

[#3]

It worked!! Thank you for keeping me sane, lol. I needed that!