Oct 05 2018 11:10 AM
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.
Oct 05 2018 11:29 AM - edited Oct 05 2018 11:31 AM
SolutionHi 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
Oct 08 2018 05:40 AM
It worked!! Thank you for keeping me sane, lol. I needed that!
Oct 05 2018 11:29 AM - edited Oct 05 2018 11:31 AM
SolutionHi 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