Microsoft Office Tutorials and References
In Depth Information
Converting a table back to a range
Conditional formatting is an easy way to quickly identify erroneous cell entries or cells of
a particular type. You can use a format (such as bright-red cell shading) to make particular
cells easy to identify.
Figure 19.11 shows a worksheet with nine ranges, each with a different type of conditional
formatting rule applied. Here’s a brief explanation of each:
Greater than ten: Values greater than ten are highlighted with a different
background color. This rule is just one of many numeric-value-related rules that
you can apply.
Above average: Values that are higher than the average value are highlighted.
Duplicate values: Values that appear in the range more than once are highlighted.
Words that contain X: If the cell contains X (upper- or lowercase), the cell is
Data bars: Each cell displays a horizontal bar, the length of which is proportional
to its value.
This worksheet demonstrates a few conditional formatting rules.