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...
If you want some other ideas, you can apply a conditional format to the input range so that any blanks are coloured to flag them as requiring data. If you wish to be more aggressive in the way you handle uncooperative users, then you could test the input range
= OR(ISNONTEXT(input))
and trash the calculation if it contains invalid data. For example, a workbook calculating tax liability could override the input numbers to set all tax rates to zero.
