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?