How to Highlight Values that are Above Average

Using conditional formatting, you can quickly highlight the cells with the values above or below the average. Please check how to highlight values that are below the average, or follow the steps below to highlight cells with the values above the average:

Step 1: Select the data cells or range;

Step 2: Click the "Home" tab from the Ribbon;

Step 3: Click the "Conditional Formatting" command in the "Styles" section;

Step 4: Click the "Top/Bottom Rules" from the drop-down list, then select "Above Average" from the extended list;

Step 5: Format the numbers above the average, e.g., font and cell color;

Step 6: Click "OK" at the bottom and the numbers above the average will be in a different color.

Leave a Reply