Highlight Items Above Average

August 17, 2023 - by Bill Jelen

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.

Home, Conditional Formatting, Top/Bottom Rules, Above Average... — Figure 1277. The top/bottom rules are new.

This article is an excerpt from Power Excel With MrExcel

Title photo by Hamed Daram on Unsplash