Microsoft Excel Functions & Formulas

Use validation to allow data input by a

specific criterion

A range is defined to allow data input as long as it is not locked

through a criterion specified in cell D1. Allow data input only if the

value 1 is entered in cell D1. Again, we use data validation in com-

bination with a custom-defined formula to get the solution for this

exercise.

4

To allow data input by one specified criteria:

1. Enter data in cells A1:A10 as shown in Figure 12-3, and

select cells A1:A10.

2. On the Data menu, click Validation.

3. In the Settings tab, select Custom from the Allow

drop-down.

4. Type the formula =$D$1=1.

5. Select the Error Alert tab.

6. Enter a custom error message. ...