Excel - Clear Rules

---

---

One of the enriched spices in the Conditional Formatting menu is Clear Rules. Removing the conditional formatting rules that you defined previously for the active worksheet can be done through the Clear Rules. It increases the reusability of the Excel worksheet and permits you to apply different conditional formatting rules in the same worksheet.

Rules of Clear Conditional Formatting

Various ways to clear Conditional Formatting rules are given below −

• Clear Rules From Selected Cells
• Clear Rules From Entire Sheet
• Clear Rules From Table
• Clear Rules From PivotTable

Lets elaborate these rules one by one.

Clear Rules From Selected Cells

Suppose you have an Excel worksheet with many conditional formatting rules deployed. Lets assume you intend to clear the rules from the C column.

First, select the cell range C2:C15 in the C column. Go to the Home tab and expand the "Conditional Formatting" tile and select "Clear Rules" from the drop-down menu; choose "Clear Rules from Selected Cells".

Therefore, the Icon sets rules from the C column have been successfully removed, as shown below −

Clear Rules From Entire Sheet

Below are the following steps to remove the conditional formatting rules from the active worksheet.

Step 1 − Consider the sample Excel worksheet, where many Conditional Formatting Rules, such as Color Scales and Icon Sets, are defined earlier. First, you can select the A2:D15 cell in the Excel worksheet.

Step 2 − After that, select "Home ->Conditional Formatting->Clear Rules->Clear Rules from the Entire Sheet".

Therefore, multiple conditional formatting rules, such as icon set rules and color scale rules, have been cleared from the worksheet.

Clear Rules From Table

Lets say we have a table where multiple conditional formatting rules are set. The goal is to remove the Conditional Formatting Rules from the defined table.

Select the table range A1:G15 and then navigate to the Hometab, Conditional Formatting, and expand the "Clear Rules". After that, you can select the "Clear Rules from This Table" option from the drop-down menu.

Note − The "Clear Rules from This Table" option is disabled if the table is not created in the worksheet.

Once you click on "Clear Rules from This Table," the conditional formatting rules are removed from the table.

Clear Rules From PivotTable

Below are the steps to remove the conditional formatting rules from the table. First, you need to create a pivot table and apply the conditional formatting rules to that pivot table. Otherwise, the Clear Rules from this PivotTable option will be disabled.

Step 1 − The Icon set Indicators "3 Flag" rule has been applied in the given pivot table. Select the pivot table having cell range A3:B32.After that, select "Home ->Conditional Formatting->Clear Rules->Clear Rules from This PivotTable".

Step 2 − Therefore, the rules have been removed from the pivot table.