Excel 2016 Tips and Tricks

Lesson 1 – Using Conditional and Custom Formats

Excel 2016

8. Select the desired formatting option. 9. Select .



S TEP - BY -S TEP Add a second conditional format to a range.

If necessary, display the Qtr1 worksheet.

Steps

Practice Data

1. Select the range of cells to which you wish to apply a second conditional format. 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. Point to the Highlight Cells Rules or the Top/Bottom Rules option. The appropriate submenu opens. 6. Enter one or more values you want use as the criteria in the appropriate boxes, if applicable. The criteria appear in the boxes. 7. Select the formatting list on the right of the dialog box. A list of available options is displayed. 8. Select the desired formatting option. The formatting option is selected. 5. Select the desired option. The appropriate dialog box opens.

Click

Point to Highlight Cells Rules

Click Greater Than

Type 2100 in the Format cells that are GREATER THAN box

Click

Click Green Fill with Dark Green Text

Page 8

OFFICEPRO, Inc.