You would have seen this in various online forms, where you must fill a cell before moving to the other. 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.
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: