Apple Pages '09 - Manual (Page 215)

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 field to add a condition.
The condition you specify in the topmost field is applied if the number entered doesn’t
satisfy any of the other conditions. Text Element conditions can only be used in this
topmost field. To learn about Text Elements, see “Creating a Custom Text Format” on
page 217.
5 From the pop-up menu above the new format field, choose a condition item.
6 Define the number format you want to apply when a number meets the condition by
adding elements to the format field.
See “Creating a Custom Number Format” on page 207 for information about
interacting with the format field.