LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default excel 2007 - copying cells with conditional formating

How can I avoid copy & paste of cells with conditional formatting to mess up
and extend the rules list when pasting?

I copy a cell with conditional formatting from a "template" (it has 3
rules). All I want is to paste that to OVERWRITE the existing format rules
in my destination cells with the ones from the template. Instead, it ADDS
the rules from my template to the existing list of rules ?!? Eaching time I
change the rules in the template and paste them to the destination files,
they all end up with 6 rules, then 9, then 12...

I can I avoid this without having re-correct each single cell in each of my
files I copy my template to?

Thankx for your help


 
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
copying conditional format in a range of cells in excel 2007 reghog Excel Worksheet Functions 1 April 6th 09 12:02 PM
Copying conditional formating Paul Excel Discussion (Misc queries) 5 January 26th 09 02:06 PM
Conditional Formating/Excel 2007 to 2003 Christopher Hogan Excel Discussion (Misc queries) 1 January 22nd 09 04:30 AM
Conditional Formating copying (Max Min) Excelicious Excel Worksheet Functions 3 April 3rd 08 06:47 PM
Conditional Formating in Excel 2007 peter Excel Worksheet Functions 0 July 13th 07 10:58 PM


All times are GMT +1. The time now is 07:12 AM.

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

About Us

"It's about Microsoft Excel"