Microsoft Office Tutorials and References
In Depth Information
Validating data for correctness during entry
Create a validation rule (continued)
6 Click the Data down arrow and then click the condition that you
want to validate.
7 Type the appropriate values in the boxes.
8 Click the Input Message tab.
9 Select the Show Input Message When Cell Is Selected check box.
10 Type a title for the Input Message box.
11 Type the message that you want Excel to display when the cell is
clicked.
12 Click the Error Alert tab.
13 Select the Show Error Alert After Invalid Data Is Entered check box.
14 Click the Style down arrow.
15 Click the style of alert that you want for your message.
16 Type a title for the error message box.
17 Type the error message that you want.
18 Click OK.
12
9
10
11
14
13
16
8
15
17
18
6
7
Search JabSto ::




Custom Search