How can I deactivate conditional formatting if the cell is empty?
You can achieve this by setting your conditional format to trigger on
"Formula is" rather than "Cell Value is". Write an AND statement like
this:
=AND(C8<"",C8="abc")
This triggers the conditional format in cell C8 when that cell is not
blank and when it contains the entry abc. If the cell is blank the AND
formula is false and does not trigger the conditional formatting.
Dave O
|