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.