Find cells that have conditional formatting

Do any of the following:

Find all cells with conditional formatting

  1. On the Edit menu, click Go To.

  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. Select a cell that has the conditional formatting you want to find.

  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.

See also

Highlight patterns and trends with conditional formatting

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×