Automatic percentage calculation that shows the amount of cells changed in colour

Hi Community,

this is the situation: I have a column with like 10 rows, on top there is additionally a grey cell. If the colour of the 10 white cells is changed to green, I want to see a number in percentage in the Grey cell that Shows how many White cells are green now.

For example: the colour of 2 of the 10 white cells are changed to green, so the number shown in the grey cell should be 20%. this should be shown and adjusted automatically.


Do you guys have an idea how to do that? Unfortunately I do not have any programming or vba-skills, using Google didnt help me.


Thanks in advance,

j123

here you go, thanks!

Looks good at first glance, thank you! we Need to consider that the colour of the cells could be red or just different, but it should only count the cells if the cell is green. additionally I need the counting-cell(the Grey one) to be in percentage, do you think that's possible to implement?