Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy conditional formatting, paste format without conditions | Excel Discussion (Misc queries) | |||
Copy/Paste Conditional Format | Excel Discussion (Misc queries) | |||
Is it possible to copy a conditional format formula as paste value | Excel Discussion (Misc queries) | |||
Copy & paste conditional format | New Users to Excel | |||
Code instead of copy n' paste the conditional format by hand | Excel Programming |