Microsoft Office Tutorials and References
In Depth Information
Understanding Conditional Formatting Visualization
Conditional formatting enables you to apply cell formatting selectively and automatically, based
on the contents of the cells. For example, you can specify that all negative values in a range have
a light yellow background color. When you enter or change a value in the range, Excel examines
the value and checks the conditional formatting rules for the cell. If the value is negative, the
background is shaded. If not, no formatting is applied.
Beginning with Excel 2007, Microsoft significantly enhanced conditional formatting to include
several visualization features: data bars, color scales, and icon sets. This tip describes these
features, which you access by using the Home
Conditional Formatting drop-down control.
Using the data bars conditional formatting can sometimes serve as a quick alternative to creating
a chart. Figure 54-1 shows results from a survey, using data bars to visualize the responses. Data
bars conditional formatting is much improved in Excel 2010. For example, you can now use solid
bars (rather than gradients), you can specify minimum and maximum scale values, and negative
numbers are handled correctly.
Figure 54-1: These tables use data bars conditional formatting.