Tuesday, 22 April 2014

How to display an Error Message for an Invalid Entry in Microsoft Excel 2010

Data validation is used to control the type of data or the values that users enter into a cell.
The instructions below demonstrates how to display an error message for an invalid entry:

1. Select one or more cells to validate.
2. On the [Data] tab, in the [Data Tools] group, click [Data Validation].
3. On the [Settings] tab, select your validation criteria for your data.
4. In the [Data Validation] dialog box, click the [Error Alert] tab. See diagram below:

Note.  Make sure that the [Show error alert after invalid data is entered] check box is selected.

5. Select one of the following options for the [Style] box:
  • Stop - To prevent entry of invalid data.
  • Warning - displays a warning message that does not prevent entry of invalid data. 
  • Information - displays an information message that does not prevent entry of invalid data.
6. Enter a title in the [Title] box.
7. Enter a message in the [Error message] box.
8. Click OK.