Most valuable professional
  • Excel Book Excerpt

Excel Select Every Kid in Lake Wobegon

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Select Every Kid in Lake Wobegon

Problem: Sometimes I need to use conditional formatting to choose all the cells that are above average or I need to highlight cells in the top fifth percentile. This was really hard to do in Excel 97-2003.

Strategy: The Conditional Formatting menu offers a whole new range of formatting options. You can choose cells that are above average, below average, and so on.


Figure 1121 The top/bottom rules are new.

Additional Details: You can actually adjust the options with “10” to show the top or bottom 5, 2, 20, or any number. When you choose one of the “10” options, a new Top 10 Items dialog box will appear, where you can choose how many items or what percentage to show.

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: