I'm sure there are a lot of threads on this subject and I have looked at A LOT of them, however, I am not familiar enough with VBA to modify the codes specifically to what I want. After reading an e-mail, if there is a post that addresses specifically what I need, then please direct me there. Otherwise, I'd appreciate some help.

I have formatted the cells in column H, which contain an expiration date, to turn red when it is either 7 days away from the date or on/past the date.

In addition to this, I would like to send an e-mail based on the addresses in column C (with the recipient name from column B) when the condition in column H is met (i.e. when it is 7 days away). I would like this e-mail to send automatically.

I've fiddled with Ron de Bruin's codes but cannot seem to get it to work with my specifics and not the "yes/no" condition he has.

If someone can help me out, I'd greatly appreciate it.

Thanks!