Remarks cell based on the color of the names and the averages | Help !

[X_23]

 Hello again. In the photo above I want the remarks specific to each gender to be displayed in the remarks cell based on the color of the names and the averages

[#2]

@X_23 

I wouldn't use colors for this. Instead, add a column that lists the gender (male or female) of the student.

I'd also add a column to the table at the bottom with the thresholds of the scores:1, 5 and 8

You can then use a lookup formula.

[#3 · Accepted solution]

Hello for adding value to the topic. I used the CountByFontColor function provided by the kutools extension with the SI function@Hans Vogelaar