HomeMicrosoft OfficeMicrosoft ExcelExcel 2007: Locate Cells Containing Conditional Formatting

Excel 2007: Locate Cells Containing Conditional Formatting

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.

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES

2 COMMENTS

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android