Editing conditional formatting formula, arrow keys insert range.

Editing conditional formatting formula, arrow keys insert range.

Post by Qm9iIEFybm » Thu, 21 May 2009 06:44:01


Whenever I am entering or editing a conditional formatting formula, if I try
to move to another place within the formula using the arrow keys, a range is
inserted into the formula rather than just moving my typing insertion point.
Is there any way to prevent this other than always using the mouse to
relocate within the formula?
 
 
 

Editing conditional formatting formula, arrow keys insert range.

Post by Gord Dibbe » Thu, 21 May 2009 07:00:30

Hit the F2 key before arrowing.

The status bar message will change from "Enter" to "Edit"


Gord Dibben MS Excel MVP

On Tue, 19 May 2009 14:44:01 -0700, Bob Arnett