Microsoft Office Tutorials and References
In Depth Information
Chapter 19: Conditional Formatting and Data Validation
and Data Validation
In This Chapter
An overview of Excel’s conditional formatting feature
Practical examples of using conditional formatting formulas
An overview of Excel’s data validation feature
Practical examples of using data validation formulas
This chapter explores two very useful Excel features: conditional formatting and data validation.
You may not think these features have much to do with formulas. As you’ll see, though, when you
toss formulas into the mix, conditional formatting and data validation can perform some amazing
Conditional formatting enables you to apply cell formatting or visualizations (such as icons or
color scales) selectively and automatically, based on the contents of the cells. For example, you
can set things up such 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 evaluates the
conditional formatting rules for the cell. If the value is negative, the background is shaded. If not, no
formatting is applied.
Conditional formatting has improved significantly in Excel 2007 and Excel 2010, and is
now even more useful for visualizing numeric data. In some cases, you may be able to
use conditional formatting in lieu of a chart.