In Excel 2007, you can apply your conditional formats to a multi-cell range.
Just select the range in the formatting dialogue.

Tyro

"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