Functions for Conditional Formatting
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 ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
