Forum Discussion
Solved
Remarks cell based on the color of the names and the averages | Help !
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
Hello for adding value to the topic. I used the CountByFontColor function provided by the kutools extension with the SI functionHansVogelaar
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.
Hello for adding value to the topic. I used the CountByFontColor function provided by the kutools extension with the SI functionHansVogelaar