Hello
I am looking for a way to create an alert or reminder of some sort for two different problems.
I am creating a training sheet which will outline when a person is booked, approved and attending training and also when that training expires. At the moment, we do not have a sufficient system in place in keeping track of training which has not been approved or declined (sitting idle) and I was looking to have some sort of reminder for when that cell is blank.
I have looked through threads and found some which alert you when closing the spreadsheet but, as authorisation comes from a different department, we would not likely know the outcome on that day.
The relevant cells would be: Status = F2 and Expiry Date = I2
As I am not very experienced in excel, I'm not sure if that would be possible but would be interested in knowing how to do such things.
I would also like to use something like this to alert us when training is due to expire.
Any help would be much appreciated.
Thanks
Bookmarks