Microsoft Office Tutorials and References
In Depth Information
Establishing Data-Validation Rules
Figure 1-9:
A
datavalidation
rule in
action.
Table 1-1
Data-Validation Rule Categories
Book III
Chapter 1
Rule
What Can Be Entered
Any Value
Anything whatsoever. This is the default setting.
Whole
Number
Whole numbers (no decimal points allowed). Choose an operator
from the Data drop-down list and values to describe the range of
numbers that can be entered.
Decimal
Same as the Whole Number rule except numbers with decimal
points are permitted.
List
Items from a list. Enter the list items in cells on a worksheet,
either the one you’re working in or another. Then reopen the Data
Validation dialog box, click the Range Selector button (you can find it
on the right side of the Source text box), and select the cells that hold
the list. The list items appear in a drop-down list on the worksheet.
Date
Date values. Choose an operator from the Data drop-down list and
values to describe the date range. Earlier in this chapter, “Entering
date and time values” describes the correct way to enter date values.
Time
Time values. Choose an operator from the Data drop-down list and
values to describe the date and time range. Earlier in this chapter,
“Entering date and time values” describes the correct way to enter
a combination of date and time values.
Text
Length
A certain number of characters. Choose an operator from the Data
dropdown list and values to describe how many characters can be entered.
Custom
A logical value (True or False). Enter a formula that describes what
constitutes a true or false data entry.
Search JabSto ::




Custom Search