If you select the whole range starting with A1 the format will be applied
accordingly, note that A1 needs to be the active cell

replace A1 with the first cell in the range you want to test


--


Regards,


Peo Sjoblom



"Ash" wrote in message
...
I've noticed most of the responses give the formatting criteria for a
single
cell reference. Is it possible to do it for the entire column?

Thanks a bunch!

"Ash" wrote:

Is it possible to use conditional formatting for more than one set value?

For example, if a cell has a value of either 01,02,03,04,05,96,97,98, or
99,
I want to highlight the cell. I've searched the help function and the
website and don't see anything that specifically addresses this question.

Any help is greatly appreciated!