Use Data Validations for MS Excel

This option is used to restrict the valid value for the row or column. Following are the Steps:

1. Select the column or the valid value for the row or cloning.  Following are the steps :
2. Click on Data Tab. 
3. Click on Data Validation option in Data Tools Group.  Box.  Which will open the following window? 
4. Then click on "Setting'tab.
5. Click on Allow drop down and select category of number.  (whole number, decimal etc.) 
6. After the click on Data drop down and select the setting (between,  equal to,  less than etc.) and fill the range value as per the requirement (Minimum & Maximum). 
7. Then Click on 'Input Message's tab and type the required message. 
8. Finally click on 'Error Alert'tab and type the message. 
9. Select the style (stop,  warning, Information)