May 27 2022 02:07 AM
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 a sort of mock videogame on excel. I've been mostly successful, but on the monster attack screen, I've noticed that my meticulously placed conditional formatting rules are changing randomly in order for absolutely no discernible reason. This is extremely problematic to me, because this screen has, very literally, hundreds of formatting rules, and them being in the correct order is quintessential to it functioning properly.
At the most basic level, a CHOOSE(RANDBETWEEN( function is selecting a character as a target for an attack, and another CHOOSE(RANDBETWEEN( function is selecting a specific attack. The damages of all possible attacks against all possible targets exists in a series of columns, but they're all in white font until that specific target and specific attack are randomized, in which case they turn black and become readable to the player. The idea is that the damage of that attack against that specific target is meant to appear only when that specific target and attack are randomized, and remain white any time they aren't as to not muddy the hell out of the game with a bunch of irrelevant values. When the rules remain in the correct order, this works without a problem; when they change order without me doing anything, however, it all falls apart.
I've gone through the worksheet on multiple occasions and cell-by-cell correctly reordered the rules (a miserable process that took about an hour each time) but every time I fixed some rules, other rules that I had previously fixed randomly reordered themselves again.
I'm at my wit's end with this. If anyone has any idea what's happening and how I can get the rules to stop changing order on their own, I would be extremely appreciative.
May 27 2022 05:17 AM
May 27 2022 10:09 AM
May 27 2022 10:33 AM
@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.
May 28 2022 12:41 AM
Aug 15 2023 12:51 AM
Same problem here.
Drives me crazy.
The problem is known for at least 7 years.
Microsoft doesn't seem to care about bugs, if the majority of users won't run into them regularly (there are more excamples for this experience
unfortunately).