Hi,
I need your help please. I will try my best to explain what i need.
At my work i had to create a spreadsheet using excel 2010 to keep a record of individuals training codes and there expiry dates. These dates will expire 60 months or 36 months of start date.
So I created a spreadsheet with a list of staff names and all they training codes. (That's the easy part).
This is where i need your help. Is they a way to run a macro or rule in excel, so I only input a start date of a training code and it will automatically highlight that cell red when it reaches 60 months of the date inputted? and the same for 36 months.
Also if it could highlight yellow 30 months before the 60 months to give a warning that the training needs to be done, and 18 months before 36 months.
Help Please!
Many thanks
Archie
Bookmarks