Excel 2016 Tips and Tricks

Lesson 1 – Using Conditional and Custom Formats

Excel 2016

10. Enter the new criterion. 11. Select . 12. Select .



S TEP - BY -S TEP Edit a Conditional Formatting rule.

If necessary, display the Qtr1 worksheet.

Steps

Practice Data

1. Select the range of cells that you wish to edit. The range of cells is highlighted as you select them.

Select B3:D6

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

Release the mouse button

3. Select the Conditional Formatting button in the Styles group on the Home tab. The Conditional Formatting menu opens. 4. Select the Manage Rules option. The Conditional Formatting Rules Manager dialog box opens.

Click

Click Manage Rules

5. Select the rule you want to change.

Click Cell Value > 2000

The selected rule is highlighted.

6. Select the Edit Rule button.

Click

The Edit Formatting Rule dialog box opens.

7. If you wish to change the

Click the second (currently greater than )

condition, select the condition list. A list of available options is displayed.

8. Select the new condition.

Click less than

The new condition appears in the box.

Page 6

OFFICEPRO, Inc.