excel conditional formatting

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