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

Hi,

The best thing to do is that once you past everything you need to copy to
your current spreadsheet is "Select All" cells(you can use keyboard shortcut
Ctrl E). Once everything is selected, go to the "Styles" Group in the "Home
Tab" and click in "Conditional Formatting" and scroll all the way down where
it says "Manage Rules."

A new windows should show up and list of all the rules that are used in the
spreadsheet. Select "Delete Rule" to eliminate any old conditional formatting
rules you may want to forget.

Hope this helps,
--
Vicente Tulliano


"dbott" wrote:

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

Mmmm.... I have over 100 conditional rules per file I use my template for,
making it longer to do this below than re-editing every single cell affected
by the Cut&Paste one by one. That's why I was simply looking to overwrite,
just like previous versions of Excel did marvelously ;-)

Can this new "feature" be disabled?

"vttotal" wrote:

Hi,

The best thing to do is that once you past everything you need to copy to
your current spreadsheet is "Select All" cells(you can use keyboard shortcut
Ctrl E). Once everything is selected, go to the "Styles" Group in the "Home
Tab" and click in "Conditional Formatting" and scroll all the way down where
it says "Manage Rules."

A new windows should show up and list of all the rules that are used in the
spreadsheet. Select "Delete Rule" to eliminate any old conditional formatting
rules you may want to forget.

Hope this helps,
--
Vicente Tulliano


"dbott" wrote:

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