Microsoft Office Tutorials and References
In Depth Information
Analyze Cell Values with Color Scales
Chapter 5: Analyzing Excel Data
5 Click the color scale that
has the color scheme you
want to apply.
Excel applies the color
scales to each cell in the
Did You Know?
Excel color scales come in two varieties:
3-color scales and 2-color scales. If your
goal is to look for outliers or to make value
judgments about your data, go with a
3-color scale because outliers stand out
more, and you can assign your own values
to the colors (such as positive, neutral, and
negative). Use a 2-color scale when you
want to look for patterns in the data, as a
2-color scale offers less contrast.
If you no longer require the color scales,
you can remove them. Follow steps 1 to
3 to select the range and display the
Conditional Formatting drop-down
menu, and then click Manage Rules.
Excel displays the Conditional Formatting
Rules Manager dialog box. Click the
Color Scale rule you want to remove and
then click Delete Rule.