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.
Search JabSto ::

Custom Search