Percentage calculation based on color in a training matrix

HI,

I have used supporting column to achieve the desired results if u r comfort with this , i shall ask few more question to complete the rest of the part

Note:
I have converted the Table to range for my convenience

Punnam

Yes punnam go ahead...