Microsoft Office Tutorials and References
In Depth Information
Applying Conditional Formatting
Formatting Tabs Galore
Right-click any cell or selected range of cells and the pop-up menu shown in Figure 5-32 appears.
Through this menu, you can choose the Format Cells command to access six tabs’ worth of formatting
commands, most of which are also represented on the Home tab. You can also use the ﬂoating formatting
toolbar, shown in Figure 5-32, to apply basic font, size, color, and numeric formatting to the selected
Conditional formatting isn’t really as
complicated as some people think. It’s simply
formatting that’s applied when certain conditions
are met. Excel 2010 has expanded its powers,
however, allowing all sorts of graphical
enhancements to be added to your worksheets, but at
its core, it’s a simple feature—define what the
conditions are (such as “Sales greater than
$5,000,000”) and tell Excel how to format the
numbers that meet that criteria (make them
bold and turn them green, for example).
The condition—Salary greater than $50,000—
is met by those records that are in green text,
with their cells highlighted with a color fill.
Creating Cell Rules
The “rules” for conditional formatting are really
just a set of criteria, or conditions, that all the
cells in a selection are compared to. The cells
that meet the conditions are then formatted
according to the rules. Figure 5-33 shows a
database of employee data, and the employees
earning more than $50,000 are highlighted.
There are two ways to set up the kind of rules
that result in such formatting, and you’ll try
each of them here.