Excel 2016 Tips and Tricks

Lesson 1 – Using Conditional and Custom Formats

Excel 2016

Steps

Practice Data

1. Select the range of cells to which you wish to apply a custom 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 Custom Format option. The Format Cells dialog box opens. 5. Select the desired option. The appropriate dialog box opens.

Click

Point to Top/Bottom Rules

Click Top 10 Items

Click the

value to 5

Click

Click Custom Format

9. Select the required tab.

Click Font , if necessary

The required tab is displayed.

10. Select the formatting, as desired. The desired formatting is selected.

Click Bold in the Font style list box

11. Select OK .

Click

The Format Cells dialog box closes.

12. Select OK .

Click

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

Page 10

OFFICEPRO, Inc.