Find cells that meet specific criteria in Excel 2007

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.

Related posts:

1. Sum cells with multiple criteria in Excel 2007
2. Average cells based on multiple criteria in Excel 2007
3. Average values based on a given criteria in Excel 2007
4. Count cells with multiple criteria in Excel 2007
5. Conditional formatting with multiple rules in Excel 2007