Author: Oscar Cronquist Article last updated on February 01, 2019

The image above shows values above average using conditional formatting applied to cell range B2:G13. Cell range B2:G13 contains 72 numbers, the average is approximately 45.39. Values equal to 46 or above are highlighted.

How to format

  1. Select cell range.
  2. Go to tab "Home" on the ribbon if you are not already there.
  3. Click on "Conditional Formatting" button.
  4. Click on "Top/Bottom Rules".
  5. Click on "Above Average".
  6. A dialog box appears, see image above. The drop-down list contains preconfigured formattings. "Custom Format.." opens another dialog box with more detailed settings.