Hi all,
I have a conditional formatting formula applied to column F that looks like this:
=ISERROR(MATCH(F2,Rules!$A$2:$A$8,0))
It is designed to highlight cells that are not filled with a text value from the list on the "Rules" worksheet.
Currently, it is highlighting every cell that is blank for obvious reasons.
I need to adapt it so that it either:
a) only applies at all if there is a value in the A column for that row, OR
b) ignores the rule if the cell is blank
Thanks in advance!
Dan
Bookmarks