I'm have a workbsheet that has a bunch of dates that show when people have completed their annual training.
What I'm trying to do is take the training dates and set up some conditional formatting to make things even more simplified for the casual user. I've looked around and I can't find any thread that covers exactly what I'm doing, although I've been close a few times.
The conditional formatting for the dates in cells B2:B210 need to reflect the following info:
(All training is due annually)
1. Dates that are due in the next 2 months (calendar months, not 60 days)
2. Dates that are due next month (calendar month, not 30 days)
3. Training that is overdue as of today (dates at least one year old)
I hope that gives enough information, and thank you in advance. I've been stumped for weeks now.