What to Know
This article explains how to conditionally format above and below average values in Excel.
When the data in those cells meet the condition or conditions specified, the chosen formats are applied.
This example covers the steps to follow to find numbers that are above average for the selected range.
These same steps can be used to find below-average values.
SelectConditional Formattingin the Styles group of the Home tab.
ChooseTop/Bottom Rules>Above Averageto bring up the conditional formatting dialog box.
Choose a formatting option for the data.
This example usesLight Red Fill with Dark Red Text.
Cells A3, A5, and A7 in the worksheet should now be formatted with the chosen formatting options.
