Excel Expert Needed

I would like to be able to send an automated email when a specific cell has been chosen, to a specific person, with a specific project number, I want the email to include the project number.

Also an automated reminder to be sent by email, after 7 days from a specific date in the the Cell.