Apply rules for Data validation

1. Select the cell(s) to use and choose Data and then   Data Validation.

2. Choose an option in the Allow drop-down menu, such as Date or whole number.

3. Under Data, choose a condition like equal to, and values to accept. 

4. To add a prompt, enter a title and message for your rule on the Input Message tab.

5. Choose Error Alert to create an invalid data entry message, and select OK.

For more info, see Apply data validation to cells.

Tip: To use data validation for drop-down menus or pick lists, see Create a drop-down list.

1. Select the cell(s) to use and choose Data and then   Data Validation.

2. Choose an option in the Allow drop-down menu, such as Date or whole number.

3. Under Data, choose a condition like equal to, and values to accept. 

4. To add a prompt, enter a title and message for your rule on the Input Message tab.

5. Choose Error Alert to create an invalid data entry message, and select OK.

For more info, see Apply data validation to cells.

Tip: To use data validation for drop-down menus or pick lists, see Create a drop-down list.

1. Select the cell(s) to use and choose Data and then   Data Validation.

2. Choose an option in the Allow drop-down menu, such as Date or whole number.

3. Under Data, choose a condition like equal to, and values to accept. 

4. To add a prompt, enter a title and message for your rule on the Input Message tab.

5. Choose Error Alert to create an invalid data entry message, and select OK.

For more info, see Apply data validation to cells.

Tip: To use data validation for drop-down menus or pick lists, see Create a drop-down list.