Chapter 24. Conditional Formatting

Questions answered in this chapter:

  • How can I visually indicate whether recent temperature data is consistent with global warming?

  • How does the Highlight Cells conditional formatting feature work?

  • How do I check or customize my rules?

  • How do data bars work?

  • How do color scales work?

  • How do icon sets work?

  • How can I color-code monthly stock returns so that every good month is indicated in one color and every bad month in another?

  • Given quarterly corporate revenues, how can I indicate quarters in which revenues increased over the previous quarter in one color and quarters in which revenues decreased from the previous quarter in another color?

  • Given a list of dates, how can I indicate weekend dates in a specific color?

Get Microsoft® Excel® 2010: Data Analysis and Business Modeling now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.