Clear Conditional Formatting Rules : Conditional Formatting « Format Style « Microsoft Office Excel 2007 Tutorial






Select the cell or a range. 
           Choose the clear rule options: 
           Clear Rules from Selected Cells, 
           Clear Rules form Entire Sheet, 
           Clear Rules from This Table, 
           Clear Rules from This PivotTable.
Choose the clear rule options: Clear Rules from Selected Cells, Clear Rules form Entire Sheet, Clear Rules from This Table, Clear Rules from This PivotTable.
Check the result.
Check the result.








3.10.Conditional Formatting
3.10.1.Conditional Formatting: Format Cell Contents Based on ComparisonConditional Formatting: Format Cell Contents Based on Comparison
3.10.2.Conditional Formatting: Format Cell Contents Based on Ranking and AverageConditional Formatting: Format Cell Contents Based on Ranking and Average
3.10.3.Applying Specialized Conditional Formatting Using Data BarsApplying Specialized Conditional Formatting Using Data Bars
3.10.4.Format Using Color ScalesFormat Using Color Scales
3.10.5.Format Using Icon SetsFormat Using Icon Sets
3.10.6.Create Conditional Formatting RulesCreate Conditional Formatting Rules
3.10.7.Clear Conditional Formatting RulesClear Conditional Formatting Rules
3.10.8.Edit Conditional Formatting Rule PrecedenceEdit Conditional Formatting Rule Precedence