Disregard conditional formatting if cell is blank
 

I am a novice. I want my cell to highlight if the value is zero. But if it
is blank, or greater than zero, I do not want it to highlight.

I imagine there is an easy way to do this but I haven't figured it out.

Can anyone help?

Thank you so much.

Disregard conditional formatting if cell is blank
 

FormatCFFormula is: =AND($A1=0,NOT(ISBLANK($A1)))

How about if the value is less than 0?


Gord Dibben MS Excel MVP

On Tue, 11 Dec 2007 16:52:01 -0800, veronica
wrote:

I am a novice. I want my cell to highlight if the value is zero. But if it
is blank, or greater than zero, I do not want it to highlight.

I imagine there is an easy way to do this but I haven't figured it out.

Can anyone help?

Thank you so much.