Find cells that have conditional formats

If your worksheet has one or more cells with a conditional format, you can quickly locate them so that you can copy, change, or delete the conditional formats. You can use the Go To Special command to find only cells with a specific conditional format or find all cells with conditional formats.

Find all cells that have a conditional format

  1. Click any cell without a conditional format.

  2. On the Home tab, in the Editing group, click the arrow next to Find & Select, and then click Conditional Formatting.

    Editing group on the Home tab

Find only cells with the same conditional format

  1. Click the cell that has the conditional format that you want to find.

  2. On the Home tab, in the Editing group, click the arrow next to Find & Select, and then click Go To Special.

    Editing group on the Home tab

  3. Click Conditional formats.

  4. Click Same under Data validation.

See Also

Copy conditional formatting

Remove conditional formatting

Apply conditional formatting in Excel 

Add, change, or clear conditional formats 

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×