I am trying to have Excel automatically send an email when the conditions of a cell are met.

Each row contains information for a different project. When one cell in the row changes to "<14" (Sometimes ">30" or ">90") I want an email sent to the party responsible for the project contained in that row. This may be a different person than the one responsible for the project on the row preceding it.

I have conditional formatting that automatically changes those cells based on the date. I've tried commands that allow emails to one person when these cells turn to one thing. I.e. Sending to me every time the cell turns to ">90", but I can't figure how to send based on different conditions and to assign different emails based on the assignment of the row.

Can anyone help or does that not make sense? Thanks.