User Guide
Chapter 4 Working with Table Cells 81
The options in the top section of the menu apply tests to numeric values. Options in
the middle section are for text values. The “With dates” option is for dates.
4 To specify a specic test value, type it into the value eld, 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 eld.
Click to select a table cell.
The cell reference eld 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 12 3 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 eld.
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.