Have a look at conditional formatting. You can use Cell Value Is less than
=TODAY() to flag dates before the current date and Cell Value Is less that
=TODAY()+7 to flag dates within the next week. Choose your formats to suit
your requirements.

--
Ian
--
"tstorie" wrote in message
...
I am tracking expiration dates for training. With numerous people working
for me, tracking their training is vital, and the easiest view for all
training classes required is on Excel. I am wondering if Excel can
automatically change the color of a date that I input as the expiration
date
approaches and as it passes.

I appreciate any help. If it is capable of doing this task, I cannot find
how to do it.