Editing Conditional formatting formula


B

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

Advertisements

K

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

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top