A spreadsheet where the cell automatically changes when the mandatory training is nearing expiration and then again when they have expired

Luke Williams 0 Reputation points
2023-10-22T11:07:05.3766667+00:00

I just want to make an excel spreadsheet where the cell automatically changes when the mandatory training is nearing expiration and then again when they have expired.

for instance.

i have a date of 01/07/2023, i would like this green. then one month from expiry id like it automatically turned yellow, then after expiry of 6 months id like it to turn red. Therefore informing managers that training is out of date. After training given a new date is to be inputted and then turned green again.

If this makes any sense, some help would be greatly appreciated.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,518 questions
{count} votes