Format d2 cell condition. Format—Conditional format. In the dialog box, select the formula on the left and enter it on the right.

= $ d2 = maximum ($ d $ 2:d $85)

Click the Format button in the dialog box. Set the font color to red and the font to bold. After confirmation, select the d2 cell, double-click the format brush, brush the total score column, and highlight the highest score. If you brush all the drama areas, the line with the highest total score will be highlighted. okay