Microsoft Office Tutorials and References
In Depth Information
Chapter 19: Conditional Formatting and Data Validation
Figure 19-7: A range that uses color scale conditional formatting.
Excel provides several two-color and 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 set other options, choose Home ➜ Styles ➜ Conditional Formatting ➜
Color Scales ➜ More Rules. This command displays the New Formatting Rule dialog box, shown in
Figure 19-8. You can also modify the colors in an existing conditional formatting rule by choosing
Home ➜ Styles ➜ Conditional Formatting ➜ Manage Rules. Select the rule and click the Edit Rule
Figure 19-8: Use the New Formatting Rule dialog box to customize a color scale.