You associate conditions with a custom number format to vary a table cell’s display characteristics based on what’s entered into the cell.

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.

  5. Click the Add (+) button to the right of the format field to add a condition.

  6. From the pop-up menu above the new format field, choose a condition option.

  7. 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 for information about interacting with the format field.

  8. Repeat steps 5 through 7 as needed to define all your conditions.

    Note:  To remove a condition, click the Delete (–) button to the right of its format field.

  9. 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.

  10. 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 in the Format pane of the Table inspector.

Was this page helpful? Send feedback.