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

Del Facebook Facebook Twitter Twitter Mail Mail

Var disse oplysninger nyttige?

Fantastisk! Har du mere feedback?

Hvordan kan vi forbedre det?

Tak for din feedback!

×