Excel cells have conditional formatting to quickly find

If one or more cells in an EXCEL worksheet have conditional formatting: When the specified condition is true, Excel is automatically applied to the format of the cell, such as cell shading or font color. , you can quickly find them to copy, change, or delete conditional formatting. You can use the Locate criteria command to find only cells with a specific conditional format, or to find all cells that have conditional formatting.

　　Find all cells that have conditional formatting

1, click any cells that have no conditional formatting.

2, on the Start tab, in the Edit group, click the arrow next to Find and select, and then click Conditional Formatting.

"Find and select"

　　Find only cells with the same conditional format

1, click the cell that has the conditional formatting you want to find.

2, on the Start tab, in the Edit group, click the arrow next to Find and select, and then click Position Criteria.

"Find and select"

3, click Conditional Formatting.

4. Under Data validation, click Same.