When Column A is Blank and Column B = "employee" I would like column C to be highlighted in red, but I cant get this to work.
I have entered this:
=and($a1:$a100="",$b1:$b100="employee") and then selected cells $C1:$c100 in format red. No luck
Any help would be much appreciated.
Thanks
Bookmarks