Forum Discussion

NummerSechs's avatar
NummerSechs
Brass Contributor
Jun 11, 2023

Cannot edit conditional formatting formula.

I am unable to edit a conditional formula. If I have a formula  =OR(B1>C1,C1>D1,D1>E1) and I want to change the formula to be =OR(B1>=C1,C1>=D1,D1>=E1) I cannot put the cursor after the ">" nor I...
excel
Zeb5585's avatar
Zeb5585
Copper Contributor
Jul 06, 2023
Helpful tip! I wish I knew that F2 trick in conditional formatting 20 years ago....

Bug still remains though - I have sheets where the mouse will not click into the conditional format formula edit box. Some days it happens less, some days more. But F2 at least is a work around to get in there with my keyboard and tweak a formula rule without restarting the entire app. 👍



Thanks!
HansVogelaar's avatar
HansVogelaar
MVP
Jul 06, 2023

Zeb5585 When you click 'Edit Rule...', can you use the Tab key to set focus to the formula box?

  • DP_24's avatar
    DP_24
    Copper Contributor
    Sep 22, 2023
    Confirming this is a bug - happening to me too with Excel 365. Mouse will not put cursor in certain positions within the formula box. The Tab key does allow to focus on the formula box but doesn't solve the issue.
  • Zeb5585's avatar
    Zeb5585
    Copper Contributor
    Jul 10, 2023
    Next time it happens I'll try that, good thinking. The keyboard hijacking i described earlier trains most people to try to fear touching their keyboard when in these formula edit dialogs. Seriously if your mouse / UI focus isn't on a spreadsheet, why hijack arrow keys? If one clicks a cell while that dialog is open set a range, well then hijack away. Sigh. Feels like the people making the software have never used the software.

    Anywho, I've got no recreate steps for the bug, it's quite random. Re: the evil workbook it was happening in, i couldn't recreate this morning when I tried, though i wasn't really exercising the software much since the sheet is in a finished state now and I don't want to mess things up. I've also got an employer who I'm sure doesn't pay me to provide free QA services to Microsoft. ;-/

Resources