HOW TO DO DATA VALIDATION IN EXCEL?
WHAT IS DATA VALIDATION IN EXCEL?
Data validation means to check the data before entry. It gives us the power to condition the values which can be entered and rejected into any cell.
BUTTON LOCATION FOR DATA VALIDATION IN EXCEL
STEPS TO DO DATA VALIDATION IN EXCEL
THE STEPS TO VALIDATE THE DATA HAS BEEN DEMONSTRATED USING AN EXAMPLE.
SCENARIO: Let us create a scenario where we need to enter the age and the age should be more than 18 and less than 30.
A cell containing the text “enter your age” is there. Next cell is the one to accept the input from the user.
Click the cell where input is to be taken and click CONDITIONAL FORMATTING button.Following dialog box will open.
THERE ARE MANY CONDITIONS. JUST CHOOSE WHICH ONE TO USE
AFTER inserting the input message, set the Error Alert.
EXAMPLE OF DATA VALIDATION
We put 31 and the cell didn’t accept the value and showed the error as we set
STEPS TO VALIDATE ALREADY FILLED DATA
Suppose we have a large data and we want to instantly find some data which fulfills our condition.
The following option gives us the option of rounding such data.
Insert the condition to choose whole numbers from 50 to 99.
Click OK and choose CIRCLE INVALID DATA from the sub menu of DATA VALIDATION BUTTON.
ONLY TWO NUMBERS SATISFY THE CONDITION.