GymWrecker
01-26-2016, 11:26 PM
I'm working on a spreadsheet and in the date column, I need the dates to change colors based on Today (). I need the date to turn "blue" when is 90 days from today; turn "orange" when it's 60 days from today; turn "green" when is 30 days from today; and turn red when the date is equal to today or past today... Please advise....
A1 = 12/31/2015
A2 = 1/21/2016
A3 = 1/2/2016
A4 = 11/15/2015
A5 = 10/15/2015
A1 = 12/31/2015
A2 = 1/21/2016
A3 = 1/2/2016
A4 = 11/15/2015
A5 = 10/15/2015