6 Replies Latest reply: Nov 7, 2016 7:37 PM by Angel Monjaras RSS

    Color By Expression Question!!!

    Lauren Mills

      This is my current color expression:

       

      if([Fundamental Towing & Job Rating with iShowroom (SSJR03WB)]='L' or [Fundamental Towing & Job Rating with iShowroom (SSJR03WB)]='S' or [Fundamental Towing & Job Rating with iShowroom (SSJR03WB)]='N', lightred(), lightgray())

       

      Which gives me this...

       

       

      However, I want to be able to give it a color range.

       

      I want "N" to be lightred() and I want S to be an ORANGE color and L to be yellow().

       

      How do I write or modify the above expression to get that?