Skip to Main Content
Microsoft® Excel® 2010: Data Analysis and Business Modeling
book

Microsoft® Excel® 2010: Data Analysis and Business Modeling

by Wayne L. Winston
January 2011
Beginner to intermediate content levelBeginner to intermediate
720 pages
23h 29m
English
Microsoft Press
Content preview from Microsoft® Excel® 2010: Data Analysis and Business Modeling

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?

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition

Wayne L. Winston
Microsoft® Excel 2010 On Demand

Microsoft® Excel 2010 On Demand

Steve Johnson - Perspection Inc.

Publisher Resources

ISBN: 9780735656864Purchase book