SOLVED

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

Brass Contributor

Remarks.png

 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 Replies

@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.

best response confirmed by X_23 (Brass Contributor)
Solution

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

1 best response

Accepted Solutions
best response confirmed by X_23 (Brass Contributor)
Solution

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

View solution in original post