Microsoft Office Tutorials and References
In Depth Information
Working with Tables in Excel
4
Click the OK
button to display
icons in each row
of the table in the %
of Quota fi eld.
icons appear next to %
of Quota percentages
based on new conditional
formatting rule
Select cell A23
(Figure 5–28).
What do the icons
represent?
In addition to the
Grade fi eld, the con-
ditional formatting
icons provide a visual
representation of
the sales reps’ prog-
ress on attaining
their sales quotas.
The green arrow and
its direction repre-
sents a grade of A,
the red arrow and its
direction a grade of
F, and the three dif-
ferent yellow arrows
and their directions
represent the B, C,
and D levels.
Figure 5–28
Working with Tables in Excel
When a table is active, the Design tab on the Ribbon provides powerful commands that
allow you to alter the appearance and contents of a table quickly. This section explores the
use of some of these commands, such as toggling total and header rows in a table.
 
 
Search JabSto ::




Custom Search