Find cells that have conditional formats

Try Office 2010 In Excel 2010, conditional formatting has been improved.
Watch a video or try Office 2010!

  1. To find all cells that have conditional formatting (conditional format: A format, such as cell shading or font color, that Excel automatically applies to cells if a specified condition is true.), click any cell.

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

  1. On the Edit menu, click Go To.
  2. Click Special.
  3. Click Conditional formats.
  4. 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.
Applies to:
Excel 2003