Hi,
I've got a large sheet with multiple conditional formats across more than one column. When I created them I selected the whole column.
Coming back to it a day later and the rule manager has them spit them up into loads of separate rules. Obviously a bit of a problem when I want to make a change.
How do I stop this from happening? (I've only deleted one row and put another back in the same place, I am pretty certain I've not made any changes that should break up the formatting as much as it does)
As an aside when I first wrote the rules I typed in G1 or whatever and when I had a look at the conditional formatting manager it had changed them all to G1076384 (or something like that), I assume that is down to selecting the whole column and the number is the bottom cell, but I'm not too bothered about that because editing it fixed it.
Cheers
I've got a large sheet with multiple conditional formats across more than one column. When I created them I selected the whole column.
Coming back to it a day later and the rule manager has them spit them up into loads of separate rules. Obviously a bit of a problem when I want to make a change.
How do I stop this from happening? (I've only deleted one row and put another back in the same place, I am pretty certain I've not made any changes that should break up the formatting as much as it does)
As an aside when I first wrote the rules I typed in G1 or whatever and when I had a look at the conditional formatting manager it had changed them all to G1076384 (or something like that), I assume that is down to selecting the whole column and the number is the bottom cell, but I'm not too bothered about that because editing it fixed it.
Cheers
