How to enable the calculation of the average score for a column in a Google spreadsheet and highlight rows that do not match the condition?

L

Leo181532018-06-21 12:53:47

Google Sheets

Leo18153, 2018-06-21 12:53:47

Good afternoon!
How to set a formula in a Google spreadsheet using conditional formatting, in which all values in rows that do not meet the condition (the average score for the column is less than 50) will be highlighted in a certain color?
Thank you in advance for your help!

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

I

iBird Rose, 2018-06-21
@iiiBird

Format - Conditional formatting.
and configure something like this skrinshoter.ru/i/210618/H55FfwNd.png