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?

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

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

1. Conditional Formatting Formula Range Number of Conditions

2. Conditional Format - Formula to Colour Every 3rd Cell in Offset Range

3. conditional formula: sum a range if text present in another range

4. Control+Arrow Key and Control + Shift+ Arrow Key Error?

5. Multiple conditional on conditional format formula

6. How do I do a complex conditional in a conditional formatting formula

7. How do I do a complex conditional in a conditional formatting formula

8. HOW TO USE CONDITIONAL FORMATTING FROM ONE RANGE TO ANOTHER RANGE

9. Excel Formula - IF Formula & Conditional Formatting

10. conditional formatting-formula vs no formula

11. How to format range of cells using Conditional Formatting-Excel?

12. Conditional formatting: format when range of cells are blank

13. Conditional formatting: How to set condition "formula" with is "date" formatted

14. Arrows as A Conditional Format

15. Conditional Formatting Arrow Icon Set

2 post • Page:**1** of **1**