Conditional Formatting Questions
If you are using Excel 2007 then you can choose STOP if TRUE with condition 1
and have
=(TODAY() - $A1533) = 7
as the second condition...
In Excel 2003 second condition will be evaluated only if first is FALSE
You can combine the two as
=AND((TODAY() - $A1533) = 7,$E1533="")
"Jim" wrote:
Hello,
I have a conditional format set in A, B, C and D to go bold if E is empty.
The formula looks like this: =$E1533=""
Cell A holds the date the line was completed
When setting up a second condition I would like cells A, B, C and D to go
red when todays date is seven or more days from the entry date shown in the A
cell.
Also, I need the red to not appear anymore once data has been entered in the
E cell.
Thanks for the help.
Jim
|