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.