Introducing Data Validation
The Data Validation feature allows you to create rules that limit the type of data that can be entered in one or more worksheet cells. The rules can limit users from entering numbers, list items, dates, or times, and you can create custom rules. You can also craft a data entry prompt that appears when the user clicks on a cell that contains Data Validation and follow up invalid entries with an error prompt. Let’s begin by comparing cells C4 and C5 on the Data Validation worksheet of this chapter’s example workbook as follows:
- Select cell C4 as shown in Figure 5.1.
Figure 5.1 – Example data for this chapter
- Choose Data | Data Validation to display the Data Validation dialog box shown in Figure 5.2.
Figure 5.2 – The Settings tab of the Data Validation dialog box
- Notice how the Allow field on the Settings tab of the dialog box is set to allow Any value. This...