Page 22 - Computer - 8
P. 22
2. Select the cell range on which you wish to apply a validation rule.
3
2
3. On the Data tab, Click the Data Validation button in the Data Tools group.
The Data Validation dialog box opens.
4
5
4. On the Settings tab, click the Allow list box arrow button and select the List option from the list
that opens.
5. In the Source box, specify the cell range that contains the permitted values for the column.
6. On the Input Message tab, specify a title and a message in the Title and Input message box
respectively.
6 7
8
7. On the Error Alert tab, specify a title, an error message, and the style for the error alert dialog box,
in case the user enters an invalid value.
8. Click the OK button.
9. Enter the data under the column headings.
9
A message is displayed under the Class heading to help you enter correct data. In case, you enter
invalid data, a dialog box informing you about the error is displayed.
20
