Saturday, 21 July 2018

microsoft excel 2010 - Is there an easy way to manage a large number of conditional formatting rules?

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.


enter image description here


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

Where does Skype save my contact's avatars in Linux?

I'm using Skype on Linux. Where can I find images cached by skype of my contact's avatars? Answer I wanted to get those Skype avat...