If you want to find numbers that are above or below average, you don’t have to calculate that average and then review the values for those higher or lower. With conditional formatting in Excel, you can automatically highlight those numbers.
Read This Article on How-To Geek ›
Source : How to Highlight Values Above or Below Average in Excel
