Microsoft Office Tutorials and References
In Depth Information
Highlighting Cells with Conditional Formats
Tom likes the formatting of the fi rst table, and wants you to format the other two tables
similarly. You cannot use the Format Painter to copy table formats, and you must format
each range as a table separately.
To format the other two tables:
1. Select the range B21:K34 .
2. In the Styles group on the Home tab, click the Format as Table button, click
Table Style Medium 6 (the sixth table style in the first row of the Medium
section), and then click the OK button in the Format As Table dialog box. The range
is formatted as a table.
3. Click the Data tab on the Ribbon, and then click the Filter button in the Sort &
Filter group to turn off the filter arrows.
4. Click the Design tab on the Ribbon, and then, in the Table Style Options group,
click the Banded Rows check box to remove the check mark and click the Last
Column check box to insert a check mark. The banded rows are removed and the
last column is formatted.
5. In the Table Styles group, click the More button, and then click Table Style
Medium 20 (the sixth table style in the third row of the Medium section). The
table is quickly reformatted with a new style.
6. Select the range C21:K21 , click the Home tab on the Ribbon, and then click the
Center button
in the Alignment group. The column headings are centered.
7. Select the range B34:K34 ; in the Styles group, click the Cell Styles button, and
then click Total (the sixth cell style in the Titles and Headings section). The Total
row is formatted.
8. Select the range B36:K49 and repeat Steps 2 through 5, select the range
C36:K36 and repeat Step 6, and then select the range B49:K49 and repeat
Step 7. The third table is formatted to match the first two tables.
Highlighting Cells with Conditional Formats
The formatting you have applied to the workbook has made the content more readable.
However, Tom also wants this worksheet to highlight important trends and sales values of
interest. For example, Tom is interested in knowing which regions and months have the
highest sales or showed the highest increase between 2011 and 2012.
You can answer these kinds of questions using conditional formats, in which the
format applied to a cell depends upon the value or content of the cell. For example, a
conditional format can make negative numbers red and positive numbers black. Conditional
formats are dynamic, so that if the cell’s value changes, the cell’s format also changes as
needed. Each conditional format has a set of rules that defi ne how the formatting should
be applied and under what conditions the format will be changed.
Search JabSto ::

Custom Search