Page 71 - Excel Data Analysis

04 537547 Ch03.qxd 3/4/03 11:50 AM Page 57

EVALUATE WORKSHEET DATA 3

You can customize the error message that You can have a message display when a user selects
displays when a user types the wrong value in a a validation cell. You do so by typing the message in
cell. In the Error Alert tab of the Data Validation the Input Message tab of the Data Validation dialog
dialog box, you select the type of error that you box. Type a title for the message in the Title field
want to display, specify a title for the message and the text of the message in the Input Message
box, and type an error message. field. For example, if you want a user to type a value
between 1 and 10 in the cell, you create a message
Excel offers three types of error messages: Stop, that reads: "Type a number between 1 and 10."
Warning, and Information. The only difference
between the three is the icon that appears on
the message box. The title you type in the Title
field appears at the top of the message box. If
you do not enter a title, "Microsoft Excel"
appears on the box. If you type a message in the
Error message field, remember to include
information about the valid values for the cell.

› Select the appropriate ■ Depending upon the ■ Excel displays an error
operator from the Data field. operator selected, the message if a user types an
Minimum, Maximum, invalid value.
ˇ Type the appropriate or both fields display.
validation value in the field
or fields that appear. Á Click OK.

57