Microsoft Office Tutorials and References
In Depth Information
Figure 2-16: Excel’s numeric formatting options are very flexible.
Excel’s conditional formatting feature is particularly useful. This feature, accessed by choosing
Home ➜ Styles ➜ Conditional Formatting, allows you to specify formatting that will be applied only
if certain conditions are met. For example, you can make cells that exceed a specified value
appear in a different color.
Excel 2007 introduced several conditional formatting options, including data bars, color scales,
and icon sets. These features have been enhanced in Excel 2010. Figure 2-17 shows the data bars
conditional formatting option that displays a histogram directly in the cells.
Figure 2-17: The data bars option is one of the conditional formatting features.