Microsoft Office Tutorials and References
In Depth Information
Just a Bit More…
To allow you to arrange your rules in the proper order, you can click on any rule in the Rules
Manager and then click the down arrow button (which the arrow in Figure 4–128 points to).
And if you’ve messed up or simply want to start over, you can purge your worksheet of all your
Conditional Formats, either for particular ranges or the entire sheet, by clicking (Figure 4–129):
Figure 4–129. The Clear Rules option
And choose the appr opriate option.
While there’s a large set of permutations crowded into Conditional Formatting, we’ve introduced
the important basics, and you’ll find that with experimentation many of its other features will come to
light.
Just a Bit More…
We can begin to wind down this rather exhaustive—and probably exhausting—résumé of formatting
with a quick look at a curiously-titled button, one holed up in the Cells Group on the Home Tab. It’s
called, as luck would have it… Format , which doesn’t tell you terribly much about what it does. But
when you click its drop-down arrow, it presents a mixed-bag of commands, some of which you wouldn’t
be inclined to call Formatting, and some of which operate on worksheets in their entirety—and we’ll
reserve those for a later chapter. In fact only the upper half of its drop-down menu, shown in Figure 4–
130, concerns us here, listing alternative ways to do some things you already know:
 
Search JabSto ::




Custom Search