Conditional formatting causing copying issues

[julhs]

I have an accounts sheet that is loaded with masses of CF rules.
Data is entered via a UserForm, that process is trouble free.

But I find that if I subsequently use copy>paste to edit/adjust a cell that it can take several minutes to complete or the whole Workbook becomes Unresponsive regardless of lapsed time and leaves me with the only option to use the Task Manager to end the process.

I’ve never been really sure as to whether the individual rules should be set to “Stop if True” or not.
ALL mine are set to “Stop if True” but viewing posts re Condition Formatting, nobody even Joe4 sets rules to “Stop if True”
So question is;
Should the rules be set to “Stop if True” or not?
Or is my issue just a matter of the sheer number of CF rules, regardless of them being set to “Stop if True” or not

 

[Fluff]

Probably just the sheer number of rules. I think the stop if True only comes into play when you have two or more conflicting rules for the same cell.

 

[julhs]

Thanks Fluff.
Had a fear that the possible reason was the sheer number, nothing I can/or prepared do about that.
I have multiple different rules for a cell that colour the cell dependant on their contents, so I will continue to use “Stop if True”.
Thankfully I don’t have the need to use copy>paste too often, will simply have to remember to copy cell “continence“ from the formula bar and paste that to the cell being edited/adjusted as opposed to the just copying and pasting the cell

Many Thanks
Julhs

 

[Fluff]

You're welcome & thanks for the feedback.