Google Sheet : Formula for Sparkline Coloring

hello all..

how to make formula in Google Sheet to coloring Sparkline based on % number
with criteria like this:
1. fill green---if number over 80%
2. fill yellow --if number 70%-80%
3. fill red --- if number <70%

i have use this formula but i don't know to completed

Please Login or Register  to view this content.

here my attachment picture

any help, thank you very much..

john m

Hi Jhon,

This should work for you.

=if(B2>80%,SPARKLINE(B14,{"charttype","bar";"color1","green"}),if(B2>=70%,SPARKLINE(B14,{"charttype","bar";"color1","yellow"}),SPARKLINE(B2,{"charttype","bar";"color1","red"})))