Mr. Biddulph:



I have been programming for over 40 years. I work mostly in operating
systems. I can make the most convoluted and obfuscated formulas you can
imagine. I choose not to because it is better to present a simple formula
and let the person receiving the formula to play with it as desired.



Tyro




David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
I don't know why you say you can't select the whole range and apply the CF
to the whole lot at once.
--
David Biddulph

"Annie" wrote in message
...
Cancel Request. I figured it out. You could not select the entire range
of
cells to apply the conditional format to. Just format the first cell,
then
right-click drag and copy format. Thanks anyway all. Leaving post in case
someone else can use it.

"Annie" wrote:

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