Forum Discussion
Cannot edit conditional formatting formula.
I can't believe I'm saying this (actually, I can believe it) - this very annoying bug is STILL there, in the current version of Excel 365, almost a year later. I've been struggling to set up some conditional formatting all morning, and, without knowing about the F2 trick mentioned here (which thankfully works to allow editing ranges with the arrow keys - the mouse still doesn't work), it's much harder than it should be because of this bug. I'm not sure if Microsoft actually takes notice of these forums at all - all the complaints here about things that don't work properly appear to be just a way for irritated users to vent.
Anyhow, add this one to the other bugs and annoyances that come up in searches from desperate users only to find someone upset about the exact same thing years (or even decades) earlier.
- acnicoletJul 24, 2025Copper Contributor
It's July 2025, and the problem still exists. I am using MS 365 for Business and have the exact same problem.