Change Cell Color based on dates

MikeL2248

New Member
Joined
Mar 1, 2019
Messages
2
Good Morning,

I am trying to format cells to change color when a specific number of days have elapsed since the input date.

Cell A1 =TODAY()
Cell C4 - J4 = Date training completed
Cells C4 - G4 needs to be Green once date is entered for initial training. When date entered is 90 past, cell changes yellow. When cell equals 120 days past, cell changes red.
Cell H4 and J4 is the same as previous only the date entered is good for one year. So colors need to change at 11 months and 12 months from date entered.
Cell J4 is good for 5 years and needs to change to yellow when date is 4 years from entry.

I have tried the EDATE formula and other conditional formatting formulas from Google with no prevail. Any assistnace would be greatly appreciated.
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

MikeL2248

New Member
Joined
Mar 1, 2019
Messages
2
Correction to cell numbering. Line 4 that states, "Cell H4 and J4" should read "Cell H4 and I4"
 

Watch MrExcel Video

Forum statistics

Threads
1,108,501
Messages
5,523,290
Members
409,508
Latest member
Afc

This Week's Hot Topics

Top