|
|
#1
06-11-2017, 05:32 PM
|
|||
|
|||
Date changes colour with age
Hi... I have a spread sheet I would like the date to change colour as the date gets older.
So when I enter todays date 12/06/2017 it will be green, in 6 months time I would like this date to change to orange and then in a years time I would like it to turn red. how do I set this up please? TIA 
|
| Thread Tools | |
| Display Modes | |
|
|
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 XP 
Office 2013
Threaded Mode