Hi there,

I have a training schedule for employees columns set up as follows

A B C D
Employeename DateTrained DateExpires Train

Column B is the date they were trained. Column C is B+90 and I would like
column D to warn me @ 7 days previous with yellow, and red on the actual day.
I would also like it to say "TRAIN" for pivot table purposes. Any advise
would be greatly appreciated. Thank you in advance!!!!
Sue