Forum Discussion

Deleted's avatar
Deleted
May 09, 2018

Conditional 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. 

Resources