Exam 77-427 Microsoft Excel 2013 EXPERT 2. Apply Custom Formats and Layouts 2.2 Apply Advanced Conditional Formatting and Filtering: Clear Rules Clear the Rules The following pages will play with the various Conditional Formatting Rules. After each example, you can Clear the Conditional Formatting. Here are the steps. Try it: Clear the Conditional Formatting Select Column H. Go to Home ->Home -> Styles. Go to Conditional Formatting. Go to Clear Rules. Select: Clear Rules from Selected Cells.   What Do You See? You can Clear Rules from Selected Cells, the Entire Sheet, this Table or from a PivotTable.

Home-> Styles-> Conditional Formatting-> Clear Rules