Colormix 2 color range when data is mostly on one side of a 1-100 spectrum

[Shouq]

Hello, 

I have a table and one of the columns has percentages ranging from 9 - 23 percent. 

I want my colour range (green to yellow to red) to be fully represented. Unfortunately, because the data is so close together and off centre, I keep getting different levels of mostly the same colour. 

I have tried different combinations but I'm not entirely sure how to fix this. 

This is my current best formula, it gives me a good range of yellow and green but completely ignores the red. 

ColorMix2(rank(total column(3))/noofrows(TOTAL),red(), yellow(), Green())
 

[Shouq]