Microsoft Office Tutorials and References
In Depth Information
Conditional Formatting
Chapter 10
Making Your Worksheet Look Good
2. Choose Home>Styles>Cell Styles. In Figure
10-29, you see that Excel displays a gallery of
predefined styles. This worksheet is using the
Composite theme.
Figure 10-29
Select from many cell styles.
Excel Styles
Figure 10-28
Choose your favorite theme.
Excel styles include Normal (the default style
for regular cell text), Heading 1 through
Heading 4 (suitable for worksheet headings),
Accent1 through Accent6 (font and fill effects
to make text stand out), and several data model
styles (Calculation, Input, Output, and so on).
Using Cell Styles
Based on themes, Cell Styles let you quickly apply a
group of formatting options to a selected group of
cells. The choices you have available depend on the
theme you choose for your document. The
following steps show you how to apply Cell Styles.
3. Excel’s Live Preview shows your choice before
you actually apply it. Select the style you
want to use.
1.
Select the cells you want to format.
Conditional Formatting
When you use conditional formatting,
you can instruct Excel to change the
formatting for a cell if the cell’s value meets
a certain criteria. You use conditional formatting to
visually annotate your data for both analytical and
presentation purposes or to easily find exceptions
Search JabSto ::




Custom Search