Microsoft Office Tutorials and References
In Depth Information
Data Validation
Figure 19-26: The Settings tab of the Data Validation dialog box.
4. Choose an option from the drop-down list labeled Allow.
The contents of the Data Validation dialog box will change and will display controls
based on your choice. To specify a formula, select Custom.
5. Specify the conditions by using the displayed controls.
Your selection in Step 4 determines what other controls you can access.
6. (Optional) Click the Input Message tab and specify which message to display when a user
selects the cell.
You can use this optional step to tell the user what type of data is expected. If this step is
omitted, no message will appear when the user selects the cell.
7. (Optional) Click the Error Alert tab and specify which error message to display when a
user makes an invalid entry.
The selection for Style determines what choices users have when they make invalid
entries. To prevent an invalid entry, choose Stop. If this step is omitted, a standard
message will appear if the user makes an invalid entry.
8. Click OK.
After you’ve performed these steps, the cell or range contains the validation criteria that you
specified.
Types of validation criteria you can apply
The Settings tab of the Data Validation dialog box enables you to specify a wide variety of data
validation criteria. The following options are available in the Allow drop-down list. Keep in mind
that the other controls in the Settings tab vary, depending on your choice in the Allow
dropdown list.
 
Search JabSto ::




Custom Search