Select Page

Excel Video 47 reviews the three sets of Top/Bottom Rules, Top/Bottom x Items, Top/Bottom x Percent, and Above/Below Average. The first thing to note is that even though Excel labels the rules Top 10 Items, etc., you can easily change to find the top or bottom item, 5 items, 50 items, etc. You can also adjust the top or bottom percentage to get exactly what you’re looking for. You may also find it helpful to format cells that are either above or below the average of the range you’re formatting.
The point of conditional formatting is to make it easy to find and react to critical data. I hope these Top and Bottom Rules are helpful in your practice.