automated email for functioned cells

[skylinekiller]

I have attached my file, I would like to have an email sent t
"skylinekiller.mail.telepac.pt" for every cell that has dropped belo
the 90 day mark (blue). On my worksheet I ahve a cell which turn
colors when the training date gets within 90 days, 30 days, and over 9
days. My question is, I was wondering if it's possible that once tha
cell falls with in the 90 days before training I want Excel t
automaticall send an email or some type of response. Is this possible

Attachment filename: training help.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=52989

 

[Ron de Bruin]

Hi skylinekiller

I don't look at your file

You can use this event to run the macro if you want to check
Formula values

Private Sub Worksheet_Calculate()
'macroname
End Sub

You can adapt this macro
http://www.rondebruin.nl/sendmail.htm#message