I have been using the following code which I got off another thread. The code works well if I manually enter the contents in column 'N', however my spreadsheet populates column 'N' from a SUMIF formula which seems to bypass the code.
DATA VALIDATION doesn't seem to work either...