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
button.
Figure 19-8: Use the New Formatting Rule dialog box to customize a color scale.
 
Search JabSto ::




Custom Search