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 either find only cells with a specific conditional format or find all cells with conditional formats.

What do you want to do?

Find all cells that have a conditional format

Find only cells with the same conditional format

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.

    Excel Ribbon Image

Top of Page

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.

    Excel Ribbon Image

  3. Click Conditional formats.

  4. Click Same under Data validation.

Top of Page

Applies To: Excel 2010



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language