help with Excel email reminders

[Copan1795]

This Excel sheet is already setup for column I to go red if the BBD is pasted the due date. I would like it to send a email when it goes red from the list email addressin column N.

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

2

IG#

Date

no of count

total count per Rec

Supplier name

Supplier item number

Supplier 's BBD Use by date

Supplier 's lot numbers

Kosher Y/N

Country of Origin from container or COA

Email

3

2/5/2018

4

5

<tbody>
</tbody>

 

[Fluff]

Duplicate of https://www.mrexcel.com/forum/excel-questions/1042758-excel-reminders.html#post5005273

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).