Forum Discussion
Deleted
May 09, 2018Conditional Formatting with formula less than or grater than
I want to create a conditional formatting to color the column (Result 11) if the average is less than or greater than "Average" column. The "Average" formula is from results 1-results 11 C2:C11. For...
SergeiBaklan
May 12, 2018Diamond Contributor
Hi Isaelda,
You may apply conditional formatting rule to your column like
=$M2<=AVERAGE($C2:$M2)