copying conditional formatting only

[Expiry]

Is there a way I can copy conditional formatting from one column to other columns, WITHOUT copying the cell format (colour, borders etc) as well?

 

[RoryA]

Which version of Excel? In 2007+ you can simply edit the range the CF applies to.

 

[Expiry]

2003, unfortunately. Although it oftens seems like Excel 1948.

 

[RoryA]

A lot of the time if you select the range with the CF and then the new ranges before going into the CF dialog, it will show you the CF applied to the original range, so you can just click OK.

 

[Expiry]

Rory, you are a genius. Perfect!

 

[RoryA]

I have my moments.