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.
Recent Questions...
ما را در سایت Recent Questions دنبال میکنید
برچسب:
نویسنده: استخدام کار
بازدید: 170
تاريخ: سه
شنبه
18 خرداد
1395 ساعت: 21:08