Count cells of a certain colour to give a percentage

[Lmaonade]

Hi,

I don't know if this is possible but please see my screenshot below of an example I've created.

I want the cell in B2 to return the % of all the cells from C2:X2 that are the green colour, these cells are green as a result of conditional formatting in the vlookup table. So B2 should return 16.66% as 3/18 of the cells are green. And B3 would return 50% as half the cells are green. Is there some formula I can use to count cells of a certain colour?

Thanks,
Andy

 

[Dossfm0q]

You are welcome