Please follow the steps below to select all the cells with conditional formatting:
Step 1: Click anywhere in the worksheet;
Step 2: Click the "Home" tab from the ribbon;
Step 3: Click "Find & Select", and select "Go To Special" from the drop-down list;
Step 4: Click "Conditional Formats" from the list;
Step 5: Click "OK" at the bottom. All cells with conditional formatting will are in different color. You can fill cells with a background color if necessary.
