Excel 2007: Locate Cells Containing Conditional Formatting
Contributed by Rob Rogers 
Tagged: Microsoft Excel Having trouble locating the cells in your worksheet that contain conditional formatting? Excel will select the cells for you, all you have to do is the following…
1. Go to the Ribbon and select Home.
2. In the Editing section, click Find & Select and select Go To Special.
3. In the Go To Special dialog box, select the radio button next to Conditional Formats.
4. Select the radio button next to All.
5. Click OK.
Excel will now select all cells containing conditional formatting.
You may also like -
Excel: How To Create a Conditional Format
Excel 2007: Clear All Formatting From a Range of Cells
Excel 2007: Highlight Duplicates
Excel 2007: Use Data Bars for Cell Value Analysis
Excel: How To Hide Formulas from Other Users
Excel 2007: Show Formulas to Verify Your Equations
Excel: Copy Formatting from One Cell or Range to AnotherHow To Copy Excel Column Widths
vivian said on November 5, 2008
very useful
Lynn Wood said on November 26, 2010
Only seems to locate the first cell in a range that contains conditional formats