email alert when date is getting close to expiring

[Shinault89]

OK, I have expiration dates in cells B3:B100 when TODAY hits that expiration day that cell turns red, in cells C3:C100 there is a Expiration day -30, when TODAY hits -30 days from expiration day that cell turns pink. I want to receive an "alert notice" via email when C3:C100 turns pink. i.e. i want a email sent to me 30 days before expiration day.

Thanks,

 

[Grand]

Do you open that Excel file everyday? We can send email via Excel but to check your expiration date you nee to have the file open.

 

[Shinault89]

No I don't, that is the problem I have some paper work that expires at different times and I need to update each one as they expire. But I don't open this file every day. Hardly ever.

 

[Grand]

I am not sure about if Windows task scheduler can open/close the file for you. Have never tried it. Other wise a server-based application can be good idea.

 

[Grand]

I forgot to ask, how that file get its data if it is hardly opened?

 

[Shinault89]

I get in when one of the documents exp. and I add the date of the new doc exp. but that is the only scenario i get in for. it is literally a sheet to keep these docs from expiring.

 

[Grand]

I can fix something that looks for expiry date and send alert emails to you via Outlook but the Excel file needs to be opened or get opened by some other system. Is that something we should go for?

 

[Shinault89]

I'm looking to see if that may be something I can do with G sheets. I can set up the Windows task if I can't get sheets to work with it.