Excel 2010 Bible

Part III: Creating Charts and Graphics

488

FIGURE 20.6

A real Excel bar chart (not conditional formatting data bars).

A color scale example

Figure 20.7 shows a range of cells that use color scale conditional formatting. It depicts the num-

ber of employees on each day of the year. This is a 3-color scale that uses red for the lowest value,

yellow for the midpoint, and green for the highest value. Values in between are displayed using a

color within the gradient.

FIGURE 20.7

A range that uses color scale conditional formatting.

On the CD
This workbook, named color scale example.xlsx, is available on the companion CD-ROM. n