Apple Keynote '09 - Manual (Page 193)

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 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 196.
5 Click the Add (+) button to the right of the format field to add a condition.