I want to color code the cells/field value with various colors. Like this below formula:
IF [NPS_Value] >= 20 THEN "GREEN" ELSEIF [NPS_Value] >= 10 THEN "GREEN" ELSEIF [NPS_Value] >= 5 THEN "PINK" ELSEIF [NPS_Value] >= 2 THEN "ORANGE"
ELSEIF [NPS_Value] >= -2 THEN "YELLOW" ELSEIF [NPS_Value] >= -5 THEN "BROWN" ELSEIF [NPS_Value] >= -10 THEN "RED" END
Problem with this is, it doesn't assign right color to this cell. Any idea to this please? Any help to this is appreciated.
8 answers
One workaround here is using Bar chart instead of shape squair, and edit axis range from 0 to 1.
Thanks,
Shin