Find cells that have conditional formatting in Excel 2016 for Mac

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, select Find, and then select 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, select Find, and then select 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.