Microsoft Office Tutorials and References
In Depth Information
The color scale conditional formatting option varies the background color of a cell based on the
cell’s value, relative to other cells in the range. Figure 54-2 shows a range of cells that use color
scale conditional formatting. The figure depicts the number of employees on each day of the
year. This 3-color scale uses red for the lowest value, yellow for the midpoint, and green for the
highest value. Values between those ranges are displayed by using a color within the gradient.
The grayscale figure doesn’t do justice to this example. The effect is much more impressive when
you view it in color.
Figure 54-2: This range uses color scale conditional formatting.
The third conditional formatting visualization option displays an icon in the cell. Which icon is
displayed depends on the value of the cell, relative to other cells. Excel 2010 provides 20 icon sets
to choose from (and you mix and match icons from different sets). The number of icons in the
sets ranges from three to five.
Figure 54-3 shows an example that uses the icon set named 3 Arrows (although only two of the
arrows are used). The symbols graphically depict the change between two test scores. If the
change is greater than or equal to five, a green up arrow is displayed. If the change is less than
–5, a red down arrow is displayed. All other change values are depicted by no icon.