Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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..... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formatting using a formula | Excel Worksheet Functions | |||
formula for conditional formatting | Excel Worksheet Functions | |||
Conditional formatting is set with a formula, but now I need to ch | Excel Discussion (Misc queries) | |||
Conditional formatting formula | Excel Discussion (Misc queries) | |||
conditional formatting with formula | Excel Worksheet Functions |