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?