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.
Along with a quick way to highlight values above or below average, you can go a step further and see those that are equal to and higher or equal to and lower. Depending on what you want to display, let’s look at how to use conditional formatting in Microsoft Excel for averages.
Set Up a Quick Conditional Formatting Rule
Open the sheet in Excel you want to work with and select the cells you want to use. You can choose a column, row, cell range, or non-adjacent cells.
Go to the Home tab and click the Conditional Formatting drop-down arrow in the Styles section of the ribbon. Move your cursor to Top/Bottom Rules and you’ll see Above Average and Below Average in the pop-out menu. Pick the one you want to use.
Read Full Article Source