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


--
nittany
------------------------------------------------------------------------
nittany's Profile: http://www.excelforum.com/member.php...o&userid=34190
View this thread: http://www.excelforum.com/showthread...hreadid=539532