25  Each rule type will change the appearance of the dialogue box, as it changes the rule description. Clear Rules clears any conditional formatting rules from the selected cells, the entire spreadsheet, the  table, or the pivot table. To clear conditional formatting: 4. Select the Rule Type. 8. Select  Conditional Formatting . 1. Hover over  Clear Rules . 2. Select the range for which to clear conditional formatting. Clear Rules 