Chapter 20: Visualizing Data Using Conditional Formatting
493
l (^) Up Arrow: When value is >= 5
l Level Arrow: When value < 5 and > –5
l (^) Down Arrow: When value is <= –5
In other words, a difference of no more than five points in either direction is considered an even
trend. An improvement of at least five points is considered a positive trend, and a decline of five
points or more is considered a negative trend.
Note
The Trend column contains a formula that references the Change column. I used the Show Icon Only option in
the Trend column, which also centers the icon in the column. n
FIGURE 20.13
The arrows depict the trend from Test 1 to Test 2.
In some cases, using icon sets can cause your worksheet to look very cluttered. Displaying an icon
for every cell in a range might result in visual overload.
Figure 20.14 shows the test results table after hiding the level arrow by choosing No Cell Icon in
the Edit Formatting Rule dialog box.