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 example M2 is greater than Average N2 so I want M2 to be colored blue since the average is less than Results 11. It seems so easy but I can't figured it out.
Hi Isaelda,
You may apply conditional formatting rule to your column like
=$M2<=AVERAGE($C2:$M2)