Excel 2016 Tips and Tricks

Excel 2016

Lesson – Using Conditional and Custom Formats

Click in any cell to deselect the range.

D ELETING A C ONDITIONAL F ORMAT  D ISCUSSION

You can clear existing rules from selected cells or from the entire worksheet by using the Clear Rules option in the Conditional Formatting menu. If you have more than one range with conditional formatting applied, you can select multiple ranges before clearing the rules.

NOTE If more than one rule applies to the selected cells, and you do not want to clear them all, then open the Conditional Formatting Rules Manager, and use the Delete Rule button to clear one rule at a time.



P ROCEDURES

1. Drag to select the range of cells from which you wish to clear the conditional formatting. 2. Release the mouse button.

3. Select the

button in the Styles group on the Home tab.

4. Point to the Clear Rules option. 5. Select the desired option.



S TEP - BY -S TEP Clearing conditional formatting rules.

Steps

Practice Data

1. Select the range of cells from which you wish to clear the conditional formatting.

Select F3:G6

The range of cells is highlighted as you select them.

2. Release the mouse button. The range of cells is selected.

Release the mouse button

OFFICEPRO, Inc.

Page 13