Using Excel 2010, I've created a very large number of conditional formatting rules. You can see how small the thumb is - there are a lot of them.
Unfortunately, the conditional rules manager dialog box is not resizable, so I can't see more than a few characters of the formula, and in many cases, I can't see all the cells that a rule applies to. I have two very similar worksheets in my workbook which need a nearly identical set of rules (same rules, just different columns in the formulas).
Are there any tools available, as add-ons, plug-ins, or otherwise, to allow for the easier managing of a large number of conditional formatting rules?
I'm at the point of manually copying each rule (rule, format, applies to & stop) to a different spreadsheet, then manually recreating each rule, in order, in the other worksheet, and this just sounds like a nightmare.

No comments:
Post a Comment