I have 200 members with different dates for different classes. Each class has to be refreshed in a different amount of months. I have a record of the last times they have taken the class, but would like to project it out 30, 60 and 90 days - and eventually color code it based on current, coming due or due.

I have tried different types of conditional formatting, and TODAY() and NOW() but I can't seem to get it to work.

Any help would be great!

Thanks,
mary