How to Select all Cells with Conditional Formatting

When using the conditional formatting, all the cells that meet the rules will be in a different color, while other cells will appear as untouched. You can select all cells with conditional formatting by using "Go To Special", please follow the steps below for details:

Step 1: Select the data range;

Step 2: Click the "Home" tab from the Ribbon;

Step 3: Click the "Find&Select" command in the "Editing" section;

Step 4: Click the "Go To Special" command from the drop-down list;

Step 5: In the new window, select "Conditional formatting";

Step 6: Click "OK" at the bottom and the cells with conditional formatting will be selected.

Leave a Reply