Conditional Formatting Questions

J

Jim

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
 
S

Sheeloo

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="")
 

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

Similar Threads

Conditional formatting with dates 7
Cobditional Formatting Rows based on dates in action plan. 0
Conditional Formatting question.... 1
Conditional formatting with two columns 0
Conditional Formating based on Date 5
Conditional Formatting Training Expiry Dates 2
Conditional Formatting in Excel 2003 2
Trouble w/ conditional formatting and dates 5

Top