You would have seen this in various online forms, where you must fill a cell before moving to the other. This makes sure that you’re restricted unless you make certain data entry (or fill a certain field).
For example, you may not be able to choose the state unless you have selected the country first.
This construct ensures that you do not miss out on filling some of the data. Something as shown below
A colleague wanted a similar construct in Excel, and the only thing that came to my mind was Data Validation.
How to Restrict Data Entry in a Cell in based on Another Cell
In this tutorial, I will show you how to restrict entries in a cell based on a formula.
Here is how you can create this in Excel
- Select cell A2.
- Go To Data –> Data Tools –> Data Validation.
- In the Settings tab go to the Allow drop down and select Custom.
- In the Formula field, type =NOT(ISBLANK($A$1)).
- Ensure that the Ignore blank is Unchecked.
- Click Ok.
Now when you enter something in cell A2, and if A1 is empty, an error will be displayed.
You May Also Like the Following Excel Tips and Tutorials: