Microsoft Office Forums - View Single Post - Date changes colour with age

Thread: Date changes colour with age

View Single Post

Old

06-11-2017, 05:32 PM

Sueade

Sueade is offline

Sueade uses Windows XP

Windows XP Sueade uses Office 2013

Sueade uses Office 2013

Office 2013

Novice

The original poster

Join Date: Jun 2015

Posts: 6

Sueade is on a distinguished road

Smile

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

Reply With Quote