This article explains how to conditionally format values above and below the average in Excel.
Conditional Above and Below Average Formatting in Excel || Basic to Advanced Microsoft Excel
Excel's conditional formatting options let you change formatting features such as background color, borders, or font formatting when data meets certain conditions. When the data in those cells meets the specified condition or conditions, the formats you choose are applied.
This example covers the steps you need to follow to find numbers that are above the average for the selected range. These same steps can be used to find values below the average.
Enter the following data in cells A1 through A7:
