Page 193 - Excel 2013 All-in-One For Dummies

✦ Data Bars represents the relative values in the cell selection by the length of the color bar in each cell — data bars are a great way to quickly pinpoint the lower and higher values within a large range of data.
✦ Color Scales classify the relative values in a cell selection with a color gradation using a one-, two-, or three-color scale — color scales are great for identifying the distribution of values across a large range of data.
✦ Icon Sets classify the values in the cell selection into three to five cat- egories and each icon within the set represents a range of values that go from high to low — icon sets are great for quickly identifying the differ- ent ranges of values in a range of data.
Figure 2-21 shows how the initial Color Scales option and Directional Icon Set appear when applied to two cell selections that both contain a simple series of whole numbers, ranging from 6 to 1 and 1 to 6. The cell range A2:A12 is formatted with Color Scales, and Live Preview shows how these values in cell range B2:B12 appear when formatted with the first Directional Icon Set.
Conditional Formatting 175
Figure 2-21:
A sequence of numeric entries formatted with color scales and directional icons that graphically indicate their relative values.
Book II Chapter 2
Formatting Worksheets