5 Replies Latest reply on Mar 22, 2016 7:13 PM by Takaaki Koseki

    Threshold coloring for rows and adding a trend line.

    John Gunnels

      I'm trying to color format each row of data to color code with yellow, red or green threshold indicators while keeping the same format.  Please refer to the sheet named Text. Please see below for some examples:

       

      Utilization: if the % is between 79-81 = Green Color; between 77-78% and 82-83% = yellow; all other numbers would be red

       

      NPS ILT: if the % is between 39-41 = Green Color; between 37-38% and 42-43% = yellow; all other numbers would be red

       

       

      If I could just get couple of these examples done, I could do the rest.

       

      Also, they want a trend line at the end of row if anyone has any input on that was well.