O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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).

The Rules Manager for conditional formatting in Excel 2007 and Excel 2010.

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required