Conditional Formatting Rules Manager....

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,301
Office Version
2019, 2016, 2013
Platform
Windows
care to explain, its better options than we had in 2003
 

Comfy

Well-known Member
Joined
Dec 21, 2009
Messages
3,376
care to explain, its better options than we had in 2003
Excel 2010.

I haven't quite figured out how it happens but a rule will get split into multiple rules.

So I've been deleting them all and reinstating the initial rule with a continuous range.

Deleting rules from the window involves deleting them one by one.

I have since written a Sub that will delete all rules and re-create on workbook save.
 

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,301
Office Version
2019, 2016, 2013
Platform
Windows
I know that one, cut / copy / paste does wonders for reordering everytime
 

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,301
Office Version
2019, 2016, 2013
Platform
Windows
i deal with it when I have finished building the file and understand the rules, then create them fresh
 

Watch MrExcel Video

Forum statistics

Threads
1,095,841
Messages
5,446,824
Members
405,417
Latest member
egrospe17

This Week's Hot Topics

Top