Have excel automatically send an email when a date is near

Hi everyone,
would like to find a formula or macro which would automatically send an email to let me know when a date entered into the specific cell is coming close to expiration. e.g. if the date 01/05/2014 is entered into a cell i would like an email to be sent to me a month before the date is reached (01/04/2014).

Using Microsoft Excel 2010.

I have attached a dummy spreadsheet describing the information that is in the real spreadsheet we have.

I have conditional formatting set up which turns the cell a different colour based on the date and how soon it is approaching.
Is it possible to have excel send an automatic email to me when the cell turns green, yellow or red?

Looking forward to all responses.License sheet - Excel forum test.xlsx