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