Microsoft Office Tutorials and References
In Depth Information
Verifying Formulas Using Range Finder
In Chapter 1, cell styles were used to format much of the worksheet. This
section describes how to change the unformatted worksheet in Figure 2 – 27a to the
formatted worksheet in Figure 2 – 27b using a theme and other commands on the
ribbon. The colors and fonts that are used in the worksheet shown in Figure 2 – 27b
are those that are associated with the Basis theme.
(a) Unformatted Worksheet
(b) Formatted Worksheet
Figure 2 – 27
The following outlines the formatting suggested in the sketch of the worksheet
in Figure 2 – 3 on page EX 68.
1. Workbook theme — Basis
2. Worksheet title and subtitle
a. Alignment — center across columns A through J
b. Cell style — Title
c. Font size — title 18; subtitle 16
d. Background color (range A1:J2) — Green, Accent 1, Lighter 60%
e. Border — thick box border around range A1:J2
3. Column titles
a. Cell style — Heading 3
b. Alignment — center
4. Data
a. Dates in column J — mm/dd/yy format
b. Alignment — center data in range B4:B16
c. Numbers in column C — comma style and two decimal places; if a cell in
range C4:C12 is greater than 70, then cell appears with background color of
orange and a font color of white
d. Numbers in top row (D4:G4, I4) — accounting number format
e. Numbers below top row (D5:G12) — comma style and decimal places
Search JabSto ::

Custom Search