Excel 2016 Tips and Tricks

Excel 2016

Lesson – Using Conditional and Custom Formats

Steps

Practice Data

8. Customize the format as desired. The changes appear in the Type box.

Type ;"N/A"

9. Select OK .

Click

The Format Cells dialog box closes, and the custom format is applied to the selection.

Use the Format Painter (in the Clipboard group) to apply the newly created custom format to the range C5:C7.

Click any cell to deselect the range. Close CONDFMT.XLSX.

OFFICEPRO, Inc.

Page 17