Excel 2007: Locate Cells Containing Conditional Formatting
Contributed by shamanstears 
January 22, 2007 
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.
Add New Comment
Viewing 1 Comment
Thanks. Your comment is awaiting approval by a moderator.
Do you already have an account? Log in and claim this comment.
Do you already have an account? Log in and claim this comment.
Add New Comment