
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.
5 To specify a test value, do one of the following:
To specify a number or text, type it into the value eld to the right of the Â
pop-up menu.
If you’ve selected Between or Not Between as the logical rule, you’ll need to supply
two numbers.
To specify the value in an existing table cell, click the blue icon in the value eld, and Â
then click the table cell that contains the value you want.
If you’ve selected Between or Not Between as the logical rule, you’ll need to supply
two cell locations.
6 To specify the formatting to apply to cells that contain the test value, click Edit and
then make selections as described:
Text color well: Click it to select a color to apply to cell values.
17 6 Chapter 10 Using Tables
Kommentare zu diesen Handbüchern