Excel sets the name of the student with the highest total score in each major to blue. How to filter automatic settings through formulas? Because there is too much data, it is not convenient to set it manually. Take your data as an example. The data area is A 1: I 19.

Select I2: I 19.

Menu: Format-Conditional Format

In the pop-up dialog box, the condition 1? Select Formula on the left.

Right input? =I2=MAX(IF($D$2:$D$ 19=D2，$ I $ 2:I $ 19，))

Click the Format button to set the desired display format.

At this time, the highest branch of each class is displayed in a special format.