Copy and paste ONLY conditional format

[Mel]

Excel 2003

Hi. Anyone have a slick method or code to copy then paste only the
conditional formatting settings from one cell to another. I can't use
just Paste Special > Formats because that also transfers other
formatting such as borders and text attributes.

Thanks,
Melina

 

[JBeaucaire]

- Select the range to which you want the conditional format copied.
Make sure, however, that the cell whose conditional format you want
copied is part of the range.
- Choose Conditional Format from the Format menu. You will see the
Conditional Format dialog box. The format should already be filled in.
- Click your mouse on OK.

That's it. Excel does the rest and copies the conditional formatting,
as you desired.

 

[Mel]

Nice trick. Thanks!

-Melina