Forum Discussion
NummerSechs
Jun 11, 2023Brass Contributor
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...
Zeb5585
Jul 06, 2023Copper Contributor
Afraid you are not understanding the OP. This is a real software bug. I have the same thing happening with conditional formatting using formulas. On a sheet of even moderate complexity, with conditional formatting formulas applied to whole column ranges, the formula edit text field will at some point not accept mouse clicks any more. This means you cannot position the cursor into formulas to make adjustments.
If you close and reopen excel, you can get ONE mouse click to edit ONE formula. Next time you open conditional formatting, you again can't click in the field and must save and restart excel again to be able to edit exactly one more.
This is especially difficult since despite ANY logic saying it's a good thing to do, the left and right arrows are hijacked at all times regardless of UI focus, so you cannot cursor in to edit parts of the formula with a keyboard. (A bad design choice i won't get into here.)
Bottom line: This is not the users fault, it's a real bug that bot past Microsoft QA.
For anyone suffering this bug: CTRL-S to save, then close excel, then reopen the workseet. You'll probably be able to click the mouse one time to make a conditional formatting formula edit before the bug arrives. Rinse and repeat until your sanity wears out.
If you close and reopen excel, you can get ONE mouse click to edit ONE formula. Next time you open conditional formatting, you again can't click in the field and must save and restart excel again to be able to edit exactly one more.
This is especially difficult since despite ANY logic saying it's a good thing to do, the left and right arrows are hijacked at all times regardless of UI focus, so you cannot cursor in to edit parts of the formula with a keyboard. (A bad design choice i won't get into here.)
Bottom line: This is not the users fault, it's a real bug that bot past Microsoft QA.
For anyone suffering this bug: CTRL-S to save, then close excel, then reopen the workseet. You'll probably be able to click the mouse one time to make a conditional formatting formula edit before the bug arrives. Rinse and repeat until your sanity wears out.
Lompies_Lombard1955
Oct 17, 2023Copper Contributor
Good day. Yip it is a definite bug. I experience that as you edit it becomes more of a problem as if the cursor alignment deteriorates. When I save go ou and them come back in again I can click in the formula to move the cursor, as I edit more formulas in the same session, I have to click high in the formula line to move the cursor to that insert point, then it becomes so misaligned that clicking does not work at all. I can still highlight and select the complete formula by clicking at the back and then move cursor up and left???
I also just want to say thanks for the F2 tip, it is mighty handy! Take a hi3 for that. 🖖
I also just want to say thanks for the F2 tip, it is mighty handy! Take a hi3 for that. 🖖