View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default 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