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.

This article is an excerpt from Power Excel With MrExcel
Title photo by Hamed Daram on Unsplash