This one worked too. Thanks Gord. I sure appreciate the help from both you
and akphidelt. It was driving me nuts!

"Gord Dibben" wrote:

=AND(E6=0,(NOT(ISBLANK(E6))))


Gord Dibben MS Excel MVP


On Thu, 7 Feb 2008 20:31:01 -0800, NB wrote:

How can I get conditional formatting to treat a blank cell differently than a
0 value? If it is 0, I want a red background. If it is blank, I don't want
any special formatting. I've tried everything I can think of and Excel treats
blank cells as if they are 0. Help! Thanks! NB