Microsoft Office Tutorials and References
In Depth Information
Excel provides four 2-color scale presets and four 3-color scales presets, which you can apply to the selected
range by choosing Home ⇒ Styles ⇒ Conditional Formatting ⇒ Color Scales.
To customize the colors and other options, choose Home ⇒ Styles ⇒ Conditional Formatting ⇒ Color Scales ⇒ More
Rules. This command displays the New Formatting Rule dialog box, shown in Figure 19-7. Adjust the settings
and watch the Preview box to see the effects of your changes.
Figure 19-7: Use the New Formatting Rule dialog box to customize a color scale.
An extreme color scale example
It's important to understand that color scale conditional formatting uses a gradient. For example, if you format a
range using a 2-color scale, you will get a lot more than two colors. You'll also get colors within the gradient
between the two specified colors.
Figure 19-8 shows an extreme example that uses color scale conditional formatting on a range of more than
6,000 cells. The worksheet contains average daily temperatures for an 18-year period. Each row contains 365
(or 366) temperatures for the year. The columns are very narrow, so the entire year can be visualized.