Editing Conditional formatting formula
 

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.....

Editing Conditional formatting formula
 

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.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Brad" wrote:

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.....

Editing Conditional formatting formula
 

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

On 19 Nov, 16:40, Brad wrote:
I have the following equation set up as a conditional format (that is working
correctly)

=MONTH(DATE(VacYear,ROW()-ROW(StartPoint),COLUMN()-COLUMN(StartPoint)))<(R*OW()-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.....

Editing Conditional formatting formula
 

Duh!!! Should have thought of that.

Thank you very much!!


"KC Rippstein" wrote:

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.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Brad" wrote:

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.....