Excel 2016 Tips and Tricks

Excel 2016

Lesson – Using Conditional and Custom Formats

Steps

Practice Data

9. If you wish to change the criterion, select the current criterion. The condition or criterion is selected.

Double-click 2000

10. Enter the new criterion.

Type 1800

The new criterion appears in the box.

11. Select OK .

Click

The Edit Formatting Rule dialog box closes.

12. Select OK .

Click

The Conditional Formatting Rules Manager dialog box closes. The edited conditional formatting rule is applied to the selected cells.

Click any cell to deselect the range. Notice that the fill color of cells with values less than 1800 is light red.

A DDING A C ONDITIONAL F ORMAT  D ISCUSSION

You can have more than one conditional format for a range of cells. For instance, you can make the fill color red for cells with values less than $1800 but add a further condition that will show a different format for cells with values greater than $2100.

P ROCEDURES

1. Drag to select the range of cells to which you wish to apply a second conditional format. 2. Release the mouse button.

3. Select the button in the Styles group on the Home tab. 4. Point to the Highlight Cells Rules or the Top/Bottom Rules option. 5. Select the desired option. 6. Enter one or more values you want use as the criteria in the appropriate boxes, if applicable. 7. Select the formatting list on the right of the dialog box.

OFFICEPRO, Inc.

Page 7