Excel 2016 Tips and Tricks

Lesson 1 – Using Conditional and Custom Formats

Excel 2016

3. Select the

button in the Styles group on the Home tab.

4. Point to the Data Bars option. 5. Select the desired option.



S TEP - BY -S TEP

Using data bars.

If necessary, display the Qtr1 worksheet.

Steps

Practice Data

1. Select the range of cells to which you wish to apply a conditional format. The range of cells is highlighted as you select them.

Select F3:F6

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.

Click

4. Point to the Data Bars option. The Data Bars gallery opens.

Point to Data Bars

5. Select the desired option. The gallery closes, and the

Click Red Data Bar (first row, third column)

selected conditional formatting is applied to the selected cells.

Click in any cell to deselect the range. Notice that the red data bars in the cells vary in width depending on the value of the data in the cells. The higher the value, the wider the data bar.

Practice the concept: Select cells G3:G6 and apply green data bars to the range.

Select cells I3:I6. Display the Icon Sets gallery, then apply the 3 Flags icon set (second row, first column) to the range.

Page 12

OFFICEPRO, Inc.