Excel Digest

If you want to validate a cell to restrict data entry to a date range then follow these steps:

Select the cell you want to validate.
On the Data tab, in the Data Tools group, click Data Validation.

The Data Validation dialog box will open.

In the Data Validation dialog box, click the Settings tab.
Click on the Allow box [...]

To find cells that meet a specific criteria, for example cells with conditional formatting or cells which have data validation, proceed as follows:

In the Home tab Editing group click Find and Select.

Click on:

Formulas : to find cells that contain formulas.
Comments : to find cells that contain comments.
Conditional Formatting : to find cells that have [...]