Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Excel
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Product Information
Help and How-to
Choose your version
Training
Templates
Related Products and Technologies
Support and Feedback
Technical Resources
Additional Resources
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Find cells that have conditional formats
 
  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.

  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.

See Also
advertisement
Printer-Friendly VersionPrinter-Friendly Version