Excel 2016 Tips and Tricks

Lesson 1 – Using Conditional and Custom Formats

Excel 2016

Steps

Practice Data

5. Select the desired option.

Click Greater Than

The appropriate dialog box 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.

Type 2000 in the Format cells that are GREATER THAN box

Click

Click Light Red Fill

The formatting option is selected.

9. Select OK .

Click

The dialog box closes, and the conditional formatting is applied to the selected cells.

Click in any cell to deselect the range. Notice that the cells with values greater than 2000 are displayed with a light red fill color.

Practice the concept: Change the number in cell B6 to 2105 and press [Enter] . The cell’s fill color changes to red because the number is now greater than 2000.

C HANGING A C ONDITIONAL F ORMAT  D ISCUSSION The Conditional Formatting Rules Manager helps you create, change, edit, save and remove rules for your conditional formats.

Page 4

OFFICEPRO, Inc.