Apple numbers User Manual
Chapter 3
Using Tables
67
m
To add a stepper, click the More Cell Formats button in the Format Bar and then choose
Stepper in the pop-up menu to create a stepper with default settings.
Stepper in the pop-up menu to create a stepper with default settings.
You can also open the Cells Inspector and choose Stepper from the Cell Format pop-up
menu.
menu.
In the Cells Inspector, change the default settings if desired:
Minimum and Maximum: Indicates the lowest and highest cell values.
Increment: Indicates the amount by which the cell value increases or decreases when
you click the stepper control (or an arrow key) once.
you click the stepper control (or an arrow key) once.
Display as: Applies a number, currency, percentage, or scientific format to the cell
values.
values.
Decimals: Indicates how many decimal places to display.
Monitoring Cell Values
You can have Numbers change a cell’s fill and/or text color when its content exhibits a
particular condition.
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.
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.
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.
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 click the Cells Inspector button.
3
Select Conditional Format, and then click “Show rules.”
4
Select “Highlight cells using the following rules.”
5
Choose a condition from the “Choose a rule” pop-up menu.
The conditions in the top section of the menu apply tests to numeric values.
Conditions for text values are in the middle section of the list, and date conditions are
at the bottom.
Conditions for text values are in the middle section of the list, and date conditions are
at the bottom.
Note that the Between condition requires that you specify two numbers. The condition
is met if either of the numbers or any number in between them appears in the cell(s).
is met if either of the numbers or any number in between them appears in the cell(s).
6
Provide additional information as required to fully specify a particular condition to test
for.
for.
7
Select Fill Color and/or Text Color and click the color wells (see “Using the Colors
Window” on page 161) to define the background and value colors to apply to the cell if
the condition is met.
Window” on page 161) to define the background and value colors to apply to the cell if
the condition is met.