Search code examples
if-statementgoogle-sheets

Using Sparkline on Google Sheet

enter image description here

I just want to change color according to value but it's not working any body knows reason?

Expecting

D3=<10, return "e04848"
10<D3 AND D3<70, return "e0b848"
D3>=70 return "5789e6"

Solution

  • Can you also try replacing D3=<10 to D3<=10