Protecting Conditional Formatting

[kenlear]

I am using conditional formatting on a very active spreadsheet.

We do a lot of cutting and pasting into other sheets, and it appears to be adding many irrelevant conditional formatting rules, which eventually reach the stage where the sheet freezes and cannot always be retrieved.

Is there any way of protecting the conditional formatting on a sheet, so that it cannot be changed by cut and paste activities.

Many thanks in advance

 

[kenlear]

Is there no answer to this one?

 

[kenlear]

A final try.....

 

[Legacy 167133]

Before you paste what you have copied from the Sheet with Conditional formats, select Paste Special and select what you want to paste onto the new sheet. You can also just highlight the whole area onto which you have pasted anything, and then select Conditional Format - Clear Conditional Formats, and select your options from there.