Excel Digest

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

1. In the Home tab Editing group click Find and Select.



2. Click on:
   1. Formulas : to find cells that contain formulas.
   2. Comments : to find cells that contain comments.
   3. Conditional Formatting : to find cells that have Conditional Formatting.
   4. Constants : to find cells that contain constants.
   5. Data Validation : to find cells that have data validation.
3. More options are available if you click Go To Special. Then you will get the Go To Special dialogue where you can specify specific criteria for the cells to be found and selected.

Note:

You can search the entire sheet for the specified criteria or you can limit your search by selecting a range of cells.