Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |