Current location - Loan Platform Complete Network - Big data management - EXCEL - Use conditional formatting to highlight names in red with an average score greater than or equal to 90? How to do it? Urgent!
EXCEL - Use conditional formatting to highlight names in red with an average score greater than or equal to 90? How to do it? Urgent!

In the conditional format in the new format rules, greater than or equal to 90 points highlighted in red can be.

1, excel2010 version as an example, the following chart to select the average score of the data, click on the top of the page, "Conditional Format";

2, in the pop-up box, click on the "Highlighted Cells Rule", then In the right pop-up box, select "other rules";

3, in the pop-up rule set box, select "greater than or equal to", the right box fill in the value of 90, and then click the following "formatting "

4, in the pop-up format settings box, click on the "Fill" column, select the color you want, and finally click on the following OK can be;

5, it will return to this setup interface, click on the following OK;

6, the following chart, the can successfully average score greater than or equal to 90 points of the name highlighted in red.