Excel 2016 Tips and Tricks

Excel 2016

Lesson 1 – Using Conditional and Custom Formats

Click any cell to deselect the range. Notice that the cells containing the five highest values now have a bold font style. Also, the existing conditional formatting still applies.

U SING D ATA B ARS  D ISCUSSION

Excel enables you to create three types of conditional formats: data bars, color scales and icon sets. These formats are all visually powerful. For example, data bars display a band of color across the cell; the band’s width depends on the value of the cell in relation to other cells in the selected range.

Applying conditional formatting Data Bars

NOTE In Excel, you can preview a conditional formatting option before selecting it. By hovering the mouse pointer over a conditional formatting option, you can immediately see how it will affect the range of cells that you have selected.



P ROCEDURES

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

OFFICEPRO, Inc.

Page 11