Hello! I'm having a little trouble figuring out how to get this to run based on a formula vs a manual output.
Right now, this works and sends an email if I manually input "PAST DUE". However, there is a formula that changes the cell value to "PAST DUE" and I want the macro to run automatically whenever the formula changes the cell to "PAST DUE" (from "NOT YET DUE").
Bookmarks