Copy and paste ONLY conditional format
 

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

Copy and paste ONLY conditional format
 

- 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

Copy and paste ONLY conditional format
 

Nice trick. Thanks!

-Melina

On Jan 5, 1:57*am, JBeaucaire
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