Microsoft Office Tutorials and References
In Depth Information
Chapter 19: Conditional Formatting and Data Validation
Figure 19-13 shows a table that contains two test scores for each student. The Change column
contains a formula that calculates the difference between the two tests. The Trend column uses
an icon set to display the trend graphically.
Figure 19-13: The arrows depict the trend from Test 1 to Test 2.
This example uses the icon set named 3 Arrows, and I customized the rule:
h Up Arrow: When the value is >=5
h Level Arrow: When the value <5 and > –5
h Down Arrow: When the value is <=–5
In other words, a difference of five points or less in either direction is considered an even trend.
An improvement of more than five points is considered a positive trend, and a decline of more
than five points is considered a negative trend.
The Trend column contains a formula that references the Change column. I used the
Show Icon Only option in the Trend column.