2 Replies Latest reply on Feb 11, 2012 6:23 AM by John Grant

    Color coding rows in a data table

    John Grant

      I am trying to color code the rows in the attached data sheet based on the value of the measure “CTR”.

       

      >2% = Green

      <2% but >1% = Yellow

      < 1% = Red

       

      I remember seeing somewhere that this can be done by creating an “if/then” calculated field and placing it on the color shelf, but have been unable to recreate it.

       

      Any help would be greatly appreciated.