Alerts/Reminders

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

You would often use conditional formatting for this kind of thing. With this you can get Excel to change the colour of a cell (or group of cells) if some condition is met, so you could have, for example, the name of the employee turn to an orange background if the expiry date is within the coming 4 weeks, and to a red background if the expiry date has passed.

An alternative is to use an IF statement which can give some appropriate message in a cell if the condition is met (eg "Expiry within 4 weeks" or "Qualification lapsed").

I think you need to decide which of these approaches you want as your warning mechanism, and perhaps post a sample workbook so that the layout of your data can be seen (de-sensitize the data before posting).

Hope this helps.

Pete