Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Questions | Excel Discussion (Misc queries) | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
Conditional Format - Due Dates - 2 questions (2nd posting) | Excel Discussion (Misc queries) | |||
Conditional Format - Due Dates - 2 questions | Excel Discussion (Misc queries) | |||
Three questions on hyperlinking and conditional formatting | Excel Worksheet Functions |