Microsoft Office Tutorials and References
In Depth Information
Analyze Cell Values with Color Scales
Analyze Cell Values
with Color Scales
You can analyze the distribution of values in a
range, you can pick out anomalous values, and
you can make value judgments about the data
by applying color scales to each cell in the
When analyzing worksheet data, it is often
useful to get some idea about the overall
distribution of the values. For example, it
might be useful to know whether a range has a
lot of low values and just a few high values.
Similarly, you might want to know if the range
includes any outliers, values that are much
higher or lower than all or most of the other
Finally, you may also want to make value
judgments about your data. For example, high
sales and low numbers of product defects are
“good,” whereas low margins and high
employee turnover rates are “bad.”
You can analyze your worksheet data by using
color scales . A color scale compares the relative
values of cells in a range by applying shading
to each cell, where the shading color is a
reflection of the cell’s value.
1 Select the range you
want to work with.
2 Click the Home tab.
3 Click Conditional
4 Click Color Scales.