Thank you Tryo and David very much. I'm saving your formulas.

This is what I did in first cell.
Condition 1: Formula is =ISBLANK(A1) - No format set
Condition 2: Cell Value Is equal to 0 - Format pattern and chose color
Right-click, drag down, copy formats only.
David you are correct. I could have done the entire range. My error was
specifying A1 as blank, not the first actual cell address (which was G13) in
the range. Also, someone had changed the pattern color as a cell format -
took awhile to find that. Thanks all! Annie

"David Biddulph" wrote:

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