Forum Discussion
Solved
Conditional formatting to highlight cell with higher than the average of the row.
I have 52 weeks of shipping volume numbers sorted in 52 columns. The 53rd column is the average of the 52 weeks. Currently, I able to set a conditional format to high lite all cells in a particular r...
Use the rule with formula as
and apply it to your entire range. Only one rule. Just be careful with absolute and relative references.
Please check attached.
SergeiBaklan Ok so now I need to average those cells that are now highlighted. What is the best way to do that? I tried using the AVERAGIF formula but it is returning an error.
Your are my new favorite person!SergeiBaklan