I have a template in excel and want to restrict values in columns Pincode, State and Category to remove data entry errors. Rules for these columns are:-
Pincode: Must be number and of 6 digits only
State and Category: Must be from given list
Cells under these columns should not accept the values other than defined rules.Can any one help me how to handle this?