Change bar sparkline color

[gowhitesox99]

Hi All!

HELP!!!!

I can make a 1-10 progress bar chart no problem.

=IFERROR(SPARKLINE(C16,{"charttype","bar";"max",10}),)

This makes a decent clean 1-10 progress bar in orange. Heres the one rub, I want to the colors to be different.

1-4 light orange
5-6 medium orange
7-8 orange
9-10 dark orange

catch my drift? I can easily do a conditional formatting on the numbers part so the number 1 2 3 4 5 has a background that changes color, that one is easy.
But the actual color of the bar in the next cell I want to change as well, and for the life of me I can't figure it out. I'm fine if I have to do 10 different formulas for each cell

1 ... then a formula for 1
2 ... then a formula for 2
etc... all the way up to ten but i can't figure out how to change the color at all for the darn chart, its stuck on orange.

See my upload, I want the bar chart in column d to be the color of the background in column a and b...

 

[gowhitesox99]

After messing with it, looks like sparkline for the bar part only has solid colors (red, yellow, blue, orange, black) etc.... how about red for 1-4, yellow for 5-7 and green for 8-10. But I need to make that all 1 big formula so each cell has the option of 1-10 and the corresponding color.