Find cells that have conditional formatting

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

Find all cells with conditional formatting

  1. On the Edit menu, point to Find, and then click Go To.

    (In Excel for Mac 2011, just click Go To on the Edit menu.)

  2. Click Special.

  3. Select Conditional Formats, and then select All.

  4. Click OK.

    The cells that contain formatting are selected.

Find cells that have the same conditional formatting rules as another cell

  1. On the Edit menu, point to Find, and then click Go To.

    (In Excel for Mac 2011, just click Go To on the Edit menu.)

  2. On the Edit menu, click Go To.

  3. Click Special.

  4. Select Conditional Formats, and then select Same.

  5. Click OK.

    The cells that contain the same conditional formatting as the chosen cell are selected.

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.

×