Excel 2016 Tips and Tricks

Excel 2016

Lesson – Using Conditional and Custom Formats

appearance of negative numbers; the third section controls the appearance of zero values; and the fourth section controls the appearance of text. If only two sections exist, the first controls positive numbers and zero values and the second controls negative numbers. 4. Each section can be displayed in a different color by specifying the color in brackets at the beginning of the section (e.g., [RED] ). 5. Text in number formats must be surrounded by quotes ( “ ” ). The following number format [CYAN] #,##0.0 "per lb";[RED](#,##0.0)"per lb";"N/A" displays positive numbers in cyan, with a comma thousands separator and one decimal place, followed by the text per lb . Negative numbers are red, enclosed in parentheses, with a comma thousands separator and one decimal place, followed by the text per lb . The text N/A will appear for zero values.

You can access a custom number format by selecting Custom from the Category list on the Number page in the Format Cells dialog box; all custom number formats will then appear in the Type list box.

Creating a custom number format



P ROCEDURES

1. Select the cells to which you want to apply a custom number format. 2. Select the button in the Cells group on the Home tab. 3. Select the Format Cells option. 4. Select the Number tab.

OFFICEPRO, Inc.

Page 15