Apple Numbers '09 - Manual (Page 84)

4 To specify a specific test value, type it into the value field, to the right of the
pop-up menu.
You can also use the value in a table cell as a test value. To do so, click the small blue
circle in the value field.
Click to select a table cell.
The cell reference field appears.
Specify a cell reference by clicking a table cell. You can also type a cell reference and
press Return; see “Referring to Cells in Formulas” on page 126 for information about
writing cell references.
The Between rule requires that you specify two test values. The formatting is applied if
either of the numbers or any number in between them appears in the cell or cells.
For the “With dates” rule, before specifying a test value choose options from the pop-
up menus on both sides of the test value field.
5 To specify formatting to apply when cells contain the test value, click Edit.
Text color well: Click it to select a color to apply to cell values.
Font style buttons: Click B to show cell values in boldface, click I to show them in
italics, click U to underline cell values, or click T to apply the strikethrough style.
Fill color well: Click it to select a cell fill color.
84 Chapter 4 Working with Table Cells