Why did you use IF(A1=0,TRUE,FALSE) and not just A1=0 (which itself returns
TRUE or FALSE)?

You can get rid of the other IF too, and just have
=AND(A1=0,NOT(ISBLANK(A1))) or =AND(A1=0,A1<"")

Perhaps, Tyro, you can explain why you've added the extra IF functions?
--
David Biddulph

"Tyro" wrote in message
t...
Enter your formating with a formula such as:

=IF(ISBLANK(A1),FALSE,IF(A1=0,TRUE,FALSE))

Tryo
"Annie" wrote in message
...
Using Excel 2003, I have cells that may contain a zero, or may be blank.
I
want conditional formatting to color only those cells that have a 0. I've
tried Allen Wyatt's tips on
http://exceltips.vitalnews.com/Pages...nd_Zeroes.html
and nothing is working. Perhaps there is some option or add-on that needs
to
be checked?

A zero should change color. Blanks, no change.
Thank you to anyone who may assist with this frustrating problem.
Cheers,
Annie