LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
RAZ RAZ is offline
external usenet poster
 
Posts: 120
Default Copy Paste conditional formatting

hi,
I have conditional formating on cell T17
condition is if sum of B17 to S17 is greater than 0.5 then the cell T17
should turn red (or specified color). I am using this equation =Sum(T17:S17)
Condition is working fine on T17.

I need to copy the same conditional formatting to
T18, T20, T21, T23, T24, T26, T27 etc.

I tried copy and paste special but it wont copy conditional formatting. Is
there another way to copy paste?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy conditional formatting, paste format without conditions jasonr17 Excel Discussion (Misc queries) 6 May 2nd 08 05:52 PM
How to copy and paste conditional formatting for the cell next to Kyle Excel Discussion (Misc queries) 4 July 19th 07 08:32 PM
Conditional formatting - copy & paste to an email Gapps Excel Discussion (Misc queries) 0 July 17th 07 05:56 AM
Copy paste Conditional Formatting Bud Hughes Excel Discussion (Misc queries) 3 October 1st 05 11:28 PM
Copy Paste Conditional Formatting Bud Hughes Excel Discussion (Misc queries) 6 October 1st 05 02:33 PM


All times are GMT +1. The time now is 06:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"