View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tstorie
 
Posts: n/a
Default 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.