Forum Discussion
Conditional Formatting Rules Changing Order Randomly
Hello all, So I'm really stuck here and have no idea what to do. I'm by no means an excel guru so please don't be too technical with responses, if it can be helped. So here's the gist. I'm making ...
I would love to see this workbook!! Although there are a lot of quirks with conditional formatting, randomly changing order isn't one I've noticed. I have a problem with inserting or deleting rows causing them to procreate like rabbits so a sheet that should only have 4 rules ends up with 100s and instead of rules with 1 area they have dozens. To this end I created a macro that I can convert from conditional rules to a worksheet and then those saved parameters in the worksheet to restore the conditional rules. I have not checked to see if such macro always produces the same conditional rule order but I suspect it would. Alternatively I could imaging a macro that would just reorder these rules.
But I'm still surprised and wondering how/why this reorder is happening.
But I'm still surprised and wondering how/why this reorder is happening.
I have no experience at all with macros, unfortunately. I don't know how to build them or utilize them. But yeah, it's driving me crazy. I haven't had this problem with a single other portion of the game. It's only that sheet. I can't for the life of me figure out why it's happening.
DDHoward I found that workbook i did those macros in. Sheet 2 has the Conditional Formatting rules and Macro buttons to Clear existing CFs, Read Present rules, and Apply Rules. I use my own 'language' for defining formats and such but seem to have added some decent notes on all that.
- I really appreciate this! I'm not sure if I'll be able to use it for this project but regardless I'm thankful.