Hi all,
I am looking for help getting a formula created to send an automatic email in excel. I need an e-mail automatically sent when a cell changes to the text "Overdue". I have researched some formulas for this but the majority of formulas are based on cell value that includes numbers (<200 for example) and I am nowhere clever enough to amend it!
I have cells in my main document which change the text of a cell to "Overdue" based on the date something expires but it's this separate cell that displays "Overdue" I would like to trigger the E-mail. The photo below shows a mock example to which the cell F12 displays the "Overdue" cell. Would anyone be able to help me create the formula for this? Much thanks.
I am looking for help getting a formula created to send an automatic email in excel. I need an e-mail automatically sent when a cell changes to the text "Overdue". I have researched some formulas for this but the majority of formulas are based on cell value that includes numbers (<200 for example) and I am nowhere clever enough to amend it!
I have cells in my main document which change the text of a cell to "Overdue" based on the date something expires but it's this separate cell that displays "Overdue" I would like to trigger the E-mail. The photo below shows a mock example to which the cell F12 displays the "Overdue" cell. Would anyone be able to help me create the formula for this? Much thanks.
