Hi,

I have built a staff training tracker that uses conditional formatting to tell me when a certificate is out of date. This system is flawed as if I dont check the tracker, which I often dont have time to do peoples certificates go out of date.

Is there anyway to use Excel to send me an email or to create a warning or something to alert me as to when a certificate is going out of date.

Perhaps a macro of some sort? I'm unfamilair with macros so please be gentle!

Many thanks,

Will