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