|
|
|
|
#1
06-20-2017, 05:39 AM
|
||||
|
||||
Hi,
Sorry have been away for a few days... For me it works. The only change I would recommend is with the first formula... instead of just =TODAY(), use formula: =AND(A2<=TODAY(),DATEDIF(A2,TODAY(),"m")<6) this will keep it green until 6 months old... 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Microsoft Project 2016 print specific date range stuck on one date | martinsalmon | Project | 1 | 10-12-2016 11:36 AM |
 Date picker content control to always show current date.
|
lucky16 | Word VBA | 2 | 07-01-2016 01:14 PM |
| Project 2013 - Change GANTT Bar Colour By Main Task Date | CaelanT | Project | 1 | 02-09-2015 12:50 PM |
|
How can a document have the same date modified/create date, yes have have actual file content?
|
legaleagle | Word | 15 | 01-07-2015 06:58 PM |
| Excel pivot table with a DATE value field for some reason stops at a certain date | angie450 | Excel Programming | 2 | 08-19-2014 08:50 AM |
Windows 10 
Office 2013
Hybrid Mode