Hi Tony
I tried copying the script into my spreadsheet. I resaved as 2007 so that solved the critical errors, but it still is not promting for the correct cells.
I want the following: If there is information in Column C, then there must be something in Column B, E And K. If Column B and/or E and/or K have nothing in them (and there is something in Column C), it should prompt the user to input something in that cell.
The formula in your last post is working if something is in Column C and nothing is in column b, but it is not prompting if nothing is in column E or K on the same row.