Cell Color based on date

jrfoley3 · #1 08-26-2016, 11:27 AM

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

macropod · #2 08-26-2016, 05:49 PM

jrfoley: Kindly don't post multiple threads on the same topic. I've deleted the other two.

jrfoley3 · #3 08-26-2016, 07:58 PM

Sorry I did not see where to delete the firs one...Thanks

xor · #4 08-26-2016, 10:49 PM

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