Let Excel use color to distinguish points in the score sheet

Schools often use Excel to count scores, to get a clear view of high and low marks, distinguish between high and low points in different colors, such as: To show the scores in red, 90 points above the blue display, but how to achieve this effect? Here's an example of Figure 1 to teach you this method.

Figure 1

The method is simple, select all one discipline area, point format → conditional format, first set the condition 1, the cell value is less than 60, dot format, the font color set to red, point add, add conditions 2, cell value is greater than or equal to 90, dot format, the font color is blue, if necessary, you can also add a condition , up to three conditions, as shown in Figure 2:

Figure 2

OK, let's look at the effect, like Figure 3: Is it more intuitive?

Figure 3