Send an email using VBA when a cell value changes

[Closed]
Report
-
Can someone help? I have been struggling with this for days. VBA is something new to me and I think it hates me

I have a spreadsheet that updates based on a estimated completion dates. When the date passes the estimated completion date Column J changes to say "Overdue" and I would like to receive an email with the lab number when this happens.


Column A: Lab reference #
Column J: Lab Status
Email: ***@***