How to Highlight Values Above or Below Average in Excel
With conditional formatting in Excel, you’re able to automatically highlight those numbers. you could choose a column, row, cell range, or non-adjacent cells. Go to the Home tab and tap 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. In the pop-up window, you’ll see a few default formats in the drop-down list....