Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This doesn't work 😞
Can someone help me???
if(Kategorie=4101 or 4102,rgb(255,69,0),
if(Kategorie=4201 or 4202,rgb(255,165,0),
if(Kategorie=4301 or 4302,rgb(255,255,0),rgb(135,206,255))
Might want to simplify it to this
If(Match(Kategorie, 4101, 4102), RGB(255,69,0), If(Match(Kategorie, 4201, 4202), RGB(255,165,0), If(Match(Kategorie, 4301, 4302), RGB(255,255,0), RGB(135,206,255))))
Or even this
Pick(Match(Kategorie, 4101, 4102, 4201, 4202, 4301, 4302) + 1, RGB(135,206,255), RGB(255,69,0), RGB(255,69,0), RGB(255,165,0), RGB(255,165,0), RGB(255,255,0), RGB(255,255,0))