#1
|
|||
|
|||
Cell Color based on date
Given the attached spreadsheet
How do I program Migration Date: 1. To have a green fill if Target Validation Date is greater than Today Date 2. To have a yellow fill if Target Validation Date is less than or equal to Today Date and Less than Target Validation Date + 15 days 3. To have a red fill if today’s date is greater than Target Validation date +15 and less than or equal to Migration date Thanks in advance, Jerry |
#2
|
||||
|
||||
jrfoley: Kindly don't post multiple threads on the same topic. I've deleted the other two.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Sorry I did not see where to delete the firs one...Thanks
|
#4
|
|||
|
|||
Maybe like the attached.
I don't understand your condition 2. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need help with using traffic lights in one cell based on date value in a different cell | wmedjaxnjr | Excel | 1 | 04-09-2016 04:22 PM |
Change Cell Color Based On % Complete | jrfoley3 | Project | 1 | 05-30-2013 05:24 AM |
How can I make a cell color RED under the Today's date cell? | Learner7 | Excel | 2 | 07-08-2010 12:52 AM |