Error Message for Data Validation

When you specify data validation for a cell or range of cells, you can define an error message should the user attempt to enter data that doesn’t match the data validation criteria.

Error Message is optional and is set using the Data Validation dialog - select the Validation command from the Data menu and select Error Alert to see this dialog.

See also:

Defining an Input Message to aid data entry