Forum Discussion
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 When you click 'Edit Rule...', can you use the Tab key to set focus to the formula box?
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. ;-/
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. ;-/
