Apple Keynote '08 - Manual (Page 126)

126 Chapter 6 Using Tables
3 Choose Fraction from the Cell Format pop-up menu.
4 Choose a display format from the Accuracy pop-up menu.
Using the Scientific Format
Use the scientific format to display numbers using an exponent raised by the power of
10. The exponent is displayed following an “E.” For example, the value 5.00 in scientific
format displays as 5.00E0. And the value 12345 displays as 1.2345E4.
To define a scientific format for one or more cells:
1 Select the cell or cells.
2 Click Inspector in the toolbar, click the Table Inspector button, and then click Format.
3 Choose Scientific from the Cell Format pop-up menu.
4 Use the Decimals field to specify the number of decimal places to display.
Using the Text Format
Use the text format when you want all of a cell’s content to be treated as text, even
when it’s a number.
To define a text format for one or more cells:
1 Select the cell or cells.
2 Click Inspector in the toolbar, click the Table Inspector button, and then click Format.
3 Choose Text from the Cell Format pop-up menu.
Monitoring Cell Values
You can have Keynote change a cell’s fill and/or text color when its content exhibits a
particular condition.
You define simple rules that test for the condition and then change fill and/or text color
if the condition is met. For example, you can define a rule that turns a cell blue if it
contains a particular value and another rule that turns the cell green if it contains
another value. Or you can define a rule that turns a value red when it duplicates a value
in a group of cells, or purple if the value is above average in a group of cells.
You can apply a rule to a single cell or to a range of cells. Rules applied to multiple cells
trigger color changes when any of the cells meet the rule’s condition.
To define rules:
1 Select one or more cells.
2 Click Inspector in the toolbar and then click the Table Inspector button.
3 Click Format.
4 Select Conditional Format, and then click “Show rules.”
5 Select “Highlight cells using the following rules.”