Editing Conditional formatting formula

[Brad]

I have the following equation set up as a conditional format (that is working
correctly)

=MONTH(DATE(VacYear,ROW()-ROW(StartPoint),COLUMN()-COLUMN(StartPoint)))<>(ROW()-ROW(StartPoint))

However, I find it extremely difficult to edit this formula (using the
conditional format dialog box - Edit format rule). Using arrow keys inserts
cell address's. I can't seem to find a way to show the entire formula at one
time

Do I have to copy this to a cell, make the necessary changes and then copy
the changes back as the conditional format? There's got to be an easier
way.....

 

[KC Rippstein hotmail com>]

There is...hit your F2 key. In the Status Bar (bottom of your Excel window)
you should see the word "Enter" now becomes "Edit"...this Status Bar is
always important as it always tells you what mode you are in at any given
moment.

 

[Joshua Fandango]

Hi Brad,

If you press F2 when you've got the formula box activated you can use
the arrow keys to scroll along the formula.

Cheers,
JF

 

[Brad]

Duh!!! Should have thought of that.

Thank you very much!!