If you want to find cells in your worksheet that have data validation, then follow these steps:
1. On the Edit menu, click Go To. The Go To window will open.
2. Click Special. The Go To Special window will open.
3. Click Data validation.
4. At the bottom of the window click on the radio button that says [...]
In a previous post I explained how to validate a cell using a fixed range of data. In this post we will see how to validate a cell based on the value of another cell.
Suppose we have a list of documents each with issue date and expiry date. We want to validate the expiry date [...]
If you are designing an excel sheet for other users to enter data, or even for your own use, it is a good idea to use the data validation feature to insure that only correct data will be entered. hear is how you do it:
Select the cell you want to validate.
On the Data [...]
