You can find cells in a workbook that contain data validation by using the Go To Special dialog box.
-
On the Edit menu, point to Find, and then click Go To.
-
Click Special.
-
Select Data Validation.
-
To find all cells with data validation, select All, and then click OK.
To find cells that have the same validation rules as another cell, select Same, and then click OK.
