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.
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.
