Select D2:Dn, wherever it stops.
Menu FormatConditional Formatting
Change Condition1 to Formula Is
Add a formula of =C2=TODAY()
Click Format
Select Pattern tab
Choose Red
OK
Click Add button
Change Condition2 to Formula Is
Add a formula of =AND(C2=TODAY()-7,C2<=TODAY())
Click Format
Select Pattern tab
Choose Yellow
OK

What governs the Train, if D is red or yellow?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"smack" wrote in message
...
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