Show All

Find cells that have conditional formats

1. To find all cells that have conditional formatting, click any cell.

   To find cells that have conditional formatting settings identical to the settings of a specific cell, click the specific cell.

2. On the Edit menu, click Go To.
3. Click Special.
4. Click Conditional formats.
5. Do one of the following:

   To find cells with any conditional formatting, click All below Data validation.

   To find cells with identical conditional formats, click Same below Data validation.