Excel 2003 offered a range of conditional formatting options with up to three rules. This feature has been greatly improved in Excel 2007 and Excel 2010, and now offers an unlimited number of rules. Also, in addition to standard formatting, you now have a range of color scales, data bars, and icons to choose from. There is also a Rules Manager, offering a much improved way to define and manage the rules (see Figure 5-5).
Figure 5-5. The Rules Manager for conditional formatting in Excel 2007 and Excel 2010.
In addition to simple data range selections, conditional formatting can also be applied to formulas.
In Excel ...