COUNTIF formula which shows a %

Please see attched doc.

I already have a conditional format which is working OK. I would like to put a formula in the cell so it shows a % so currently it would be 100% as there is 3 cells below showing 3 greens.

Alternativily each colour is worth a value - Green = 1, Amber = 2, Red = 3. So Cell I3 would show 3.

Help on this is appreciated, Thanks!!

Not sure I understand...

It seems to me you want to alter the colour of the cell according to the relative values of I8:I10 ... I would be inclined myself to use something like:

=SUM(COUNTIF(I8:I10,{"Green","Amber"})*({1,0.5}))

What this would do is total the values where Green = 1, Amber = 0.5 and Red = 0

The result in the sample would be 3 as you have 3 Greens, 3 Reds would be 0 and 3 Ambers 1.5 ... combinations thereof would generate a variety of results... ie 2 Ambers and 1 Red = 1, 1 Red + 2 Greens = 2 etc... you can then have a scale to determine the appropriate colour based on the 0-3 result. Is that what you want ?

(Obviously you can divide the result by 3 to get a %)