copy conditional formatting

  • Thread starter Thread starter Byrdie Ethel Pillinger
  • Start date Start date
B

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?
 
You can use the format painter to copy and paste all formats including
conditional formatting


--


Regards,


Peo Sjoblom
 
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
 
Back
Top