|
|
#1
08-26-2016, 11:27 AM
|
|||
|
|||
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 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode