Advanced Find & Select options in Sheets Windows
With Sheets, you can use the Advanced Select options to quickly locate different types of content anywhere in your document.
1. On the rightmost of the main ribbon, click Find & Select.
Depending on the data you need, click the concrete option, and Sheets will display all cells containing the specified type of content:
Data Validation
Conditional Formatting
Formulas
Comments