User guide

Chapter 10 Using Tables 193
Associating Conditions with a Custom Number Format
You associate conditions with a custom number format to vary a table cell’s display
characteristics based on what’s entered into the cell.
Here’s an example of a number format that has four conditions.
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 Click Inspector in the toolbar and click the Table button.
3 In the Table inspector, click Format.
4 Choose Custom from the Cell Format pop-up menu.
The custom format window opens.
The display format 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 196.
5 Click the Add (+) button to the right of the format eld to add a condition.