Chapter 23: Visualizing with Custom Number Formats and Shapes
23
- Click the C1 cell, go to the Formula bar, and copy the two symbols by highlight-
ing them and pressing Ctrl+C on your keyboard. - Go to your data table, right-click the percentages, and then select Format Cells.
- In the Format Cells dialog box, create a new custom format by pasting the up-
and down-triangle symbols into the appropriate syntax parts (see Figure 23.9).
In this case, any positive percentage will be preceded with the up-triangle symbol,
and any negative percentage will be preceded with the down-triangle symbol.
FIGURE 23.9
Create a custom number format using the symbols.- Click OK. The symbols are now part of your number formatting.
Figure 23.10 illustrates what your percentages look like. Change any number from
positive to negative (or vice versa), and Excel automatically applies the appropriate
symbol.FIGURE 23.10
Your symbols are now part of your number formatting.