
Chapter 9 Working with Table Cells 215
When you type this value into a cell with the
above format
The value is displayed like this
15000 Due: $0015.00K
0 Paid in Full
–500 Credit: $ (0000.50K)
Account closed Note: Account closed
To create a custom number format that has conditions:
1 Select one or more cells.
2 Choose Custom from the Cell Format pop-up menu in the Format pane of the
Table inspector.
3 From the Type pop-up menu, choose Number & Text.
4 Click the Add (+) button to the right of the format eld to add a condition.
The condition you specify in the topmost eld is applied if the number entered doesn’t
satisfy any of the other conditions. Text Element conditions can only be used in this
topmost eld. To learn about Text Elements, see “Creating a Custom Text Format” on
page 217.
5 From the pop-up menu above the new format eld, choose a condition item.
6 Dene the number format you want to apply when a number meets the condition by
adding elements to the format eld.
See “Creating a Custom Number Format” on page 207 for information about
interacting with the format eld.
Kommentare zu diesen Handbüchern