Excel 2016 Tips and Tricks

Excel 2016

Lesson – Using Conditional and Custom Formats

Steps

Practice Data

9. Select OK .

Click

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

Click any cell to deselect the range. Notice that the font color of cells with values greater than 2100 is dark green and the cells have a light green fill. The existing conditional formatting, of the light red fill color for cells with values less than 1800, still applies.

C REATING A C USTOM C ONDITIONAL F ORMAT  D ISCUSSION

Excel enables you to create your own customized conditional formats in addition to using the preset formats. By using the Custom Format option you are able to select number formats; font style, size, and color; border styles and colors; and fill colors and patterns.

P ROCEDURES

1. Drag to select the range of cells to which you wish to apply a custom 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 Custom Format option. 9. Select the required tab. 10. Select the formatting, as desired. 11. Select . 12. Select .



S TEP - BY -S TEP Creating customized conditional formats.

If necessary, display the Qtr1 worksheet.

OFFICEPRO, Inc.

Page 9