View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
USGINC
 
Posts: n/a
Default How do I track dates?

I track the safety training for our company and we have several that have to
be renewed yearly. I have an Excel spreadsheet the has the dates of the
training but I need to find a way to change the cell color (conditional
format), the only problem I am having is figuring out how to get Excel to
keep up with the current date and the training date and letting me know when
it needs to be done again. Does anyone have any suggestions ?