Microsoft Office Tutorials and References
In Depth Information
Using color scales
Two examples of color scale conditional formatting
The example on the right shows the same data, but conditional formatting was applied to each
region separately. This approach facilitates comparisons within a region and can also help
identify high or low sales months. Neither one of these approaches is necessarily better. The
way you set up conditional formatting depends entirely on what you’re trying to visualize.
Excel provides four two-color scale presets and four three-color scale 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
Formatting ➪ Color Scales ➪ More Rules. The New Formatting Rule dialog box, shown in
Figure 19.17, appears. Adjust the settings, and watch the Preview box to see the effects of
Use the New Formatting Rule dialog box to customize a color scale.