conditional formatting in 2007 excel

[hrm1220]

Is there a way to ONLY copy the formula and not the conditional format? Each time I copy a cell it brings the conditional format with it regardless if I paste special formula or a regular paste. I have 300 rows and over 256 columns with conditional formatting.

Any help would be greatly appreciated.

 

[SkipVought]

Hi,

Edit > Paste Special -- FORMULAS.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]