J John Mar 16, 2004 #1 Is there anyway that you can create a validation in a cell so that if the cell is left blank, an error message comes up?
Is there anyway that you can create a validation in a cell so that if the cell is left blank, an error message comes up?
H Harald Staff Mar 16, 2004 #2 Hi John Data > Validation, uncheck "Ignore Blanks". I guess "Allow text length > 0" would be a reasonable setting, but you may have other validation needs as well. HTH. Best wishes Harald
Hi John Data > Validation, uncheck "Ignore Blanks". I guess "Allow text length > 0" would be a reasonable setting, but you may have other validation needs as well. HTH. Best wishes Harald
