9 Replies Latest reply: Feb 28, 2014 2:45 AM by sunil kumar RSS

    Conditional Text Color in an Expression

      In a single cell I am trying to include a Conditional Text Color formula so that based on certain criteria returned values will have different colours within the one cell.

       

      The formula being used is Text Color value of the Expression is:

       

      if

      ([Sales Status Code $(=ACode)]='C', RGB(0,0,0),

        if ([Sales Status Code $(=ACode)]='E', RGB(255,0,0),

          if ([Sales Status Code $(=ACode)]='R', RGB(200,164,31),

           if ([Sales Status Code $(=ACode)]='U', RGB(0,0,255),

            RGB(0,100,0)))))

      However the only colour returned is RGB(0,100,0) for all values.

       

      Any ideas

       

      Thanks