My son is learning 2 languages at school and the vocabulary they have to learn is identical for each. The vocabulary is divided into themes (eg nature, daily routine etc) and by 2 levels (standard and higher level).

Every month leading up to the exam he has asked me to test him on his vocabulary. It gave me an idea to track it on excel, colouring the cell with the vocab word green for correct now and for previous month, yellow for correct x1 and red for incorrect. From that I should be able to do a pivot table showing French nature words 62% green, 38% red; German daily routine words 58% green, 42% yellow etc.

Except I can’t! I am completely stumped as to how to do a pivot table based on the cell fill colour.
Would anybody be able to help?

Many thanks!