Microsoft Office Tutorials and References
In Depth Information
Formatting—With Conditions
Figure 4–106. Highlighting the Highlight Cells Rules option
The route toward our objective—formatting all the sub-65 scores differently from all the other
scor e s—shoul d be a bi t cl e ar e r n ow. We wan t to highlight those scores on the basis of a less-than-65
rule —and so we need to click the Less Than… option. And when we do we see (Figure 4–107):
Figure 4–107. Low-grade format: highlighting test scores under 65
And this dialog box is pretty self-evident. Type 65 in the field to the left, and click the drop-down
arrow on the right in order to view a set of pre-defined formatting selections. We’ll choose Yellow Fill
with Dark Yellow Text. That means that all the cells in the range we selected that contain scores
dipping beneath 65 will be colored light yellow, and the numbers themselves will receive a dark yellow
ti n t. An d be for e I cl i ck OK, the ce l l s already exhibit the format in preview mode. Then just click OK and
the deed is done—and we see that Paul and Ringo—the two students whose score meet the condition
we’ve established (that’s why it’s called Conditional Formatting) experience a change in their cells.
Moreover, conditional formats remain responsive to changes in the selected cells, and they format
accordingly. If I type 85 in Paul’s cell, the yellow will disappear, because 85 obviously doesn’t meet our
less-than-65 rule. But replace Edith’s 81 with a 55, and her cell turns yellow.
And had I selected the Custom Format option from that drop-down, I would have been brought
here: (Figure 4–108):
Search JabSto ::

Custom Search