Excel 2016 Tips and Tricks

Lesson – Using Conditional and Custom Formats

Excel 2016

5. Select Custom from the Category list. 6. Select the format in the Type list box that most closely resembles the format you want to create. 7. Place the insertion point at the desired location in the Type box. 8. Customize the format as desired. 9. Select .



S TEP - BY -S TEP Create a custom number format.

Display the Bonus worksheet. You will create a custom currency format that displays the text N/A for zero values.

Steps

Practice Data

1. Select the cells to which you want to apply a custom number format. The active cell moves accordingly. 2. Select the Format button in the Cells group on the Home tab. The Format menu is displayed.

Click cell C4

Click

3. Select the Format Cells option.

Click Format Cells

The Format Cells dialog box opens.

4. Select the Number tab.

Click the Number tab, if necessary

The Number page is displayed.

5. Select Custom from the Category list. A list of available custom formats is displayed in the Type list box. 6. Select the format in the Type list box that most closely resembles the format you want to create. The format appears in the Type box. 7. Place the insertion point at the desired location in the Type box. The insertion point appears at the desired location in the Type box.

Click Custom

Scroll as necessary and click $#,##0_);($#,##0) (tenth format from the top)

Click at the end of the text in the Type box

Page 16

OFFICEPRO, Inc.