Excel: Select Every Kid in Lake Wobegon

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


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.

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.

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.

  1. The top/bottom rules are new.

For more resources for Microsoft Excel