Forum Discussion
DATA VALIDATION - DON'T ALLOW BLANK CELLS
Hello, I'm trying to create a data validation error message, where by the message will appear when the user leaves a certain cell blank. I want the user to only be able to enter text within the r...
Hello Seaneboy2020,
That could be:
Please note that if a user does not attempt to enter text into the cell, it will not prompt the data validation. For example, a user must at least double-click or press F2 in a cell to prompt the data validation.
Hi PReagan
Thank you very much for your reply.
Do you know any other solutions which could help resolve this issue? As it's most likely that the user will simply ignore the required cell, which needs to be completed.
Many thanks
Unfortunately, without running a macro, Excel does not allow this. Please review the following post for a better explanation:
https://stackoverflow.com/questions/55616477/prevent-blank-cells-with-data-validation