Excel 2016 Tips and Tricks

Excel 2016

Lesson – Using Conditional and Custom Formats



P ROCEDURES

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

3. Select the button in the Styles group on the Home tab. 4. Point to the Highlight Cells Rules or the Top/Bottom Rules option. 5. Select the desired option. 6. Enter one or more values you want use as the criteria in the appropriate boxes, if applicable. 7. Select the formatting list on the right of the dialog box. 8. Select the desired formatting option. 9. Select .



S TEP - BY -S TEP From the Student Data directory, open CONDFMT.XLSX . Apply the Highlight Cells Rules or Top/Bottom Rules options in Conditional Formatting.

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 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.

Click

Point to Highlight Cells Rules

OFFICEPRO, Inc.

Page 3