Conditional formatting will help you find the cells with the values you want, to clear the conditional formatting rules in the entire worksheet, please follow the steps below, or check here to clear conditional formatting rules in the selected areas.
Step 1: Click anywhere in the worksheet;
Step 2: Click the "Home" tab from the Ribbon;
Step 3: Click the "Conditional Formatting" command in the "Styles" section;
Step 4: Click the "Clear Rules" from the drop-down list; then select "Clear Rules from Entire Sheet" from the list to remove the rules from the entire spreadsheet;
Alternatively, select "Clear Rules from Selected Cells" from the extended list to clear the rules only for the selected section;
Step 5: For example, to clear the rules from the entire spreadsheet.