Conditional Formatting Questions
 

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

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