The title of this post may be a little misleading, but hear me out.
I have a LOT of rules for my conditional formatting... and 12 "Sheets" (Jan-Dec)
How do i copy/paste ALL the conditional formatting from "January" and paste it into "February-December"?
OR
How do i shorten this list of formatting rules? is there any way to combine any of them?
1. =$N2="CSS" (Turns columns K and L green)
2. =$N2="CSS Sigs" (Turns columns K and L green)
3. =$N2="Rater" (Turns columns K and L green)
4. =$N2="Rater Rater" (Turns columns K and L green)
i know it seems redundant... but there are a lot of checkpoints for presentations we have, and once they hit a certian point, we still need them to show "good" (green)
is there a way to combine those 4?
Bookmarks