copy conditional formatting

[Byrdie Ethel Pillinger]

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?

 

[Peo Sjoblom]

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


--


Regards,


Peo Sjoblom

 

[Gord Dibben]

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