2 Replies Latest reply on Jun 18, 2016 8:16 AM by Tom W

    Using RGB within a Calculated Field

    Victoria Mecham

      Trying to color each text

      I want Contracts Added to be a specific color and  New Jobs to be a specific color and Active Job to be a different color as well. Is there a way to do this using a formula with RGB?

       

       

      if ([Choose Sheet]="Contracts")

      then

      "Contracts Added)" ELSEIF

      ([Choose Sheet]="New Job Comparison ")

      then

      "New Job"

      ELSEIF

      [Choose Sheet] ="Active Job Comparison"

      then

      "Active Job"

      END