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

Nice trick. Thanks!

-Melina

On Jan 5, 1:57*am, JBeaucaire <JBeaucaire.3lj...@thecodecage.com>
wrote:
> - 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.
>
> --
> JBeaucaire
> ------------------------------------------------------------------------
> JBeaucaire's Profile:http://www.thecodecage.com/forumz/member.php?userid=73
> View this thread:http://www.thecodecage.com/forumz/sh...ad.php?t=46475