Microsoft Excel: Prevent Blanks

11 Apr 2011
I've been searching around the internet to try find a solution for this problem and cannot find anything.

hopefully you guys can help.

As the title says, I am trying to prevent users from leaving blank cells but of course, with data validation it only works when the user enters something into that cell.

What I want to do is when using a data input form to enter information, I want it to check to see if the user left any blanks, if so it will present an error message stating what has happened, this being that they have not completed all cells. I only need this on the white columns as these will be manual user input.

I have included a screenshot of my spreadsheet and the data input form which may show exactly what I'm asking.

Thank in advance if anyone can help me with this frustrating problem!
Aaron K
Last edited:
Top Bottom