I have been struggling with using conditional formatting in my training log to identify training that is either non-expired (green), expires in 30 days (yellow) and expired (red). Some of the training expires annually, others every three years and some does not expire. I've been able to turn cells one color or the other, but it doesn't apply correctly to various listed dates.
If anyone can help, I'd greatly appreciate it. I've attached the spreadsheet to give you a better idea what I'm trying to do.
Thank you.
Julie M.Training Log DRAFT.xlsx
Bookmarks