Conditional Formatting Cloning
Hi SS Community,
I have a colleague who has a sheet with a ton of CF rules (which are applied to months/years ie. June 22, Jul 22, Aug 22, etc). He would like to clone a rule and then change the "condition" part to different month so the same formatting will apply without having to manually re-enter the rule. ie. If " Test Aug 22" is greater than 0.90, then apply a green background to the entire column. He wants to CLONE this rule, and then change "Test Aug 22" to "Test Sept 22", and leave the rest of the rule as is. Is this possible?
From what I've been reading in similar posts, it doesn't look like SS has that capability yet, but I thought I would ask.
Thanks!
Brad
Answers
-
@Paul Newcome I know of that capability, however, if I wanted to change the "set condition" part, it erases the rest of the cloned rule and I'd have to re-enter it manually again. I was wondering if there was a way to be able to change the set condition and keep the rest of the rule without deleting it.
-
I've not had that issue before. Whenever I have cloned a rule, I can change each piece of the rule independently without affecting the other pieces.
