Highlight Above Average
Learn how to highlight cells in Google Sheets that are above average using conditional formatting. This quick tutorial guides you through the steps to apply custom formulas for effective data visualization.
I have a list of sales here and I want to highlight only those that are above average. Here's how I do it. Go. Go to format conditional formatting . apply to range a colon, a change of format . Rules to custom formula is equals A one greater than average. A colon a. These are all highlighted over here. Everything that's above average, nothing that's below average.