Microsoft Office Tutorials and References
In Depth Information
Selecting Objects
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.
 
Search JabSto ::




Custom Search