
Chapter 10 Using Tables 175
Type of data Ascending order Descending order
Text aA–zZ Zz–Aa
Dates Year (earliest rst), then Month
(January rst), then day (1-31)
Year (most current rst), then
month (December rst), then
day (31-1)
Numbers –2, –1, 0, 1, and so on 1, 0, –1, –2, and so on
Cells containing only text,
mixed with cells containing only
numbers
–2, –1, 0, 1, and so on, then
aA–zZ
Zz–Aa, then 1, 0, –1, –2, and so
on
Cells containing a mixture of
text and numbers
Values starting with numbers
rst (1z, 1Z, a1, A1)
Values starting with text rst
(A1, a1, 1A, 1z)
Empty cells At the bottom At the bottom
Boolean (TRUE, FALSE) Below text and above an
empty cell
Above text
Using Conditional Formatting to Monitor Table Cell Values
Conditional formatting changes a cell’s appearance when cells contain a test value,
which can be either a specic value that you supply or a value that matches another
value in a specic table cell.
To apply conditional formatting, you select one or more cells and then dene one or
more rules. The rules specify which visual eects to associate with cells when they
contain the test value.
Rules applied to multiple cells trigger conditional formatting when any of the cells
contains the test value.
To set up or modify conditional formatting rules:
1 Select one or more cells.
To apply the same rules to an entire table, select the entire table. Rules you dene are
applied only to the cells that are selected at the time you dene the rule.
2 Click Inspector in the toolbar, click the Table inspector button, and click Format in the
Table inspector.
3 Click Show Rules to open the Conditional Format window.
4 Choose the logical rule of your test by making a selection from the “Choose a rule”
pop-up menu.
Commentaires sur ces manuels