Data Validation

You can use Data validation to define what data is valid for individual cells or cell ranges; restricts the data entry to a particular type, such as whole numbers, decimal numbers, or text; and sets limits on the valid entries.

	a.	First select the Cells or Cell Range to validate and go to Data - Validation
	b.	Then type the Validation Criteria , Input Message and Error Alert (Style ,Title and Message) and finally click Ok

Posted in: Excel