I can set up a conditional format in one cell. I would like to copy that CF
to all the cells in the column. Any way to do that in 2007?

You can use the format painter to copy and paste all formats including
conditional formatting


--


Regards,


Peo Sjoblom


"Byrdie Ethel Pillinger"
wrote in message ...
I can set up a conditional format in one cell. I would like to copy that
CF
to all the cells in the column. Any way to do that in 2007?

Might be easier to select the entire column before setting the CF condition.

If using "Formula is:" make sure Excel does not give you Absolute reference.

i.e. =$A1 123 is the correct syntax.


Gord Dibben MS Excel MVP

On Mon, 9 Jun 2008 21:28:01 -0700, Byrdie Ethel Pillinger
wrote:

I can set up a conditional format in one cell. I would like to copy that CF
to all the cells in the column. Any way to do that in 2007?