Find Special Cells

You can use the Find & Select option to locate cells with 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.

 

Microsoft Excel will highlight the Cells with Conditional Formatting in Column H.