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 a number format that has four conditions. The top condition is applied if the
number entered doesn’t satisfy any of the other conditions.
214
Chapter 9
Working with Table Cells
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.
7
Repeat steps 4 through 6 as needed to define all your conditions.
Note: To remove a condition, click the Delete (–) button to the right of its format field.
8
In the topmost format field, define the display format you want to use if a number
doesn’t meet any of the conditions.
You can use the Entered Text element to display predefined text if a text value is
entered instead of a number. See “Creating a Custom Text Format” on page 217 for
more information.
9
In the Name field, type a name for your number format, and then click OK to save it
and apply it to selected cells.
Custom format names are listed in the Cell Formats pop-up menu n the Format pane
of the Table inspector.