Good afternoon! Hoping someone has experienced this issue before. We have established a number of conditional formatting rules for 7 drop down selections in one column labeled Site "A".
If we add a new column for Site "B" and Site "C", can those conditional formatting rules be copied from the Site "A" column without having to clone all the rules in the conditional formatting section for each column? We will most likely end up with at least 50 new columns and it is very time consuming to clone the rules for the 7 dropdown choices for each new column added.
Thank you for any advice.