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.