Find Special Cells

You can use the Find option to locate the cells which use Conditional Formatting or Data Validation.

 

The Find button is in the Editing group on the Home Ribbon. The Find icon may look different in Word and Excel (big or small), but in both programs it is still on the right side of the Ribbon.

 

Try This: Use the Find Options

Go to Home ->Editing.

Select Find and Select.

Click on Data Validation or Conditional Formatting and test the Find options.

 

Will this option find the Data Validation or Conditional Formatting on a different spreadsheet in the same workbook?