💬 Charts with Multiple Colours Replied to If you want to have multiple tiers of colors, you can nest an IFS function instead of a single IF, for example: =SPARKLINE(A1,{"charttype","bar" ; "max",100 ; "color1", IFS(A1<25 , "red" , A1<75 , "black" , A1<=100 , "green")}) pic.twitter.com/SlkExFnvdF — Ben Collins (@benlcollins) July 23, 2021 First SWITCH, now IFS. I love how the more I follow your tips Ben I think about how to clean up and consolidate some of my existing formulas.
This Article was mentioned on brid.gy
This Article was mentioned on brid.gy