Not sure this is in the correct forum, please move if needed. I have a spreadsheet with nested if statements and these if statements result in either a blank cell, OK or Due. I need a method of send an email to a given person whenever "DUE" appears and the email would need the name from column A and the module ref. from row 1. Is this possible to automate when the spread sheet is opened?