Can Excel automatically change the font color of an expired date?

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.

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" <[email protected]> wrote in message
news:[email protected]...
>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.