How to Highlight Values Above or Below Average in Excel
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.
Microsoft Excel Quick Conditional Formatting Conditional Formatting Bottom Rules Above Average Below Average
Source: howtogeek.com