Microsoft Office Tutorials and References
In Depth Information
Data Validation
Text length: Defines a minimum and maximum length for text
Custom: Allows you to define a formula to specify valid data
Depending on the option you choose, you may need to define Minimum
and Maximum values and whether you want the data to be equal to, less
than, or greater than a defined limit.
5. Click the Input Message tab in the Data Validation dialog box, as
shown in Figure 9-12.
Figure 9-12:
The Input
Message
tab lets you
display a
message
explaining
the type of
valid data
a cell can
hold.
6. Click in the Title text box and type a title.
7. Click in the Input Message text box and type a message you want to
display when someone selects this particular cell.
8. Click the Error Alert tab in the Data Validation dialog box, as shown
in Figure 9-13.
Figure 9-13:
Define
an error
message to
show if the
user types
invalid data
into the cell.
 
Search JabSto ::




Custom Search