I’m sure there’s a design reason for this, but on the off chance it’s a bug or I’m just misunderstanding something:
Why does “Clear Direct Formatting [Ctrl+M]” also clear conditional formatting rules from a cell?
I’ve had plenty of places where I want to clear only the actual direct formatting, but want to leave the conditional formatting rules in place. I’m applying the conditional formats via Cell Styles, so why are they cleared as if they’re direct?
Thankfully, since I tend to apply formatting rules by column in most of the sheets I’m designing, I can just skip one cell in my “Clear Direct Formatting” pass, and then change the range on the conditional back from $A$213 to $A:$A, or whatever. But it’s still a pain to always have to remember that extra step.
What am I missing?
EDIT: I also just discovered, much to my consternation, that “Clear Direct Formatting” ALSO includes Data validity settings. This one I sorta get, because to my knowledge it’s always going to be a direct edit. Still, it’s decidedly a pain.