Thread: Copy and paste ONLY conditional format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JBeaucaire[_143_] JBeaucaire[_143_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote