Microsoft Office Tutorials and References
In Depth Information
and a gradient ill, which you can use if you share your workbook with colleagues who
use Excel 2007.
Excel also draws data bars differently than was done in Excel 2007. Excel 2007 drew a very
short data bar for the lowest value in a range and a very long data bar for the highest
value. The problem was that similar values could be represented by data bars of very
different lengths if there wasn’t much variance among the values in the conditionally
formatted range. In Excel 2010, data bars compare values based on their distance from
zero, so similar values are summarized using data bars of similar lengths.
Tip Excel 2010 data bars summarize negative values by using bars that extend to the left of
a baseline that the program draws in a cell. You can control how your data bars summarize
negative values by clicking the Negative Value And Axis button, which can be accessed from
either the New Formatting Rule dialog box or the Edit Formatting Rule dialog box.
Color scales compare the relative magnitude of values in a cell range by applying colors
from a two-color or three-color set to your cells. The intensity of a cell’s color reflects the
value’s tendency toward the top or bottom of the values in the range.
Icon sets are collections of three, four, or five images that Excel displays when certain
rules are met.
When icon sets were introduced in Excel 2007, you could apply an icon set as a whole,
but you couldn’t create custom icon sets or choose to have Excel 2007 display no icon if
the value in a cell met a criterion. In Excel 2010, you can display any icon from any set for
any criterion or display no icon.
When you click a color scale or icon set in the Conditional Formatting Rules Manager
and then click the Edit Rule button, you can control when Excel applies a color or icon
to your data.