9 Replies Latest reply on May 4, 2018 10:40 AM by Jacynthia Spruill

    Add Colors Based on If Then Formula

    Jacynthia Spruill

      I am trying to add color to individual measures based on the formula below. I have a different if/then formula for each measure but I need the same end result. If "Excellent" or "Good", I want to be able to color green. If "Bad" I want to color Red. Please see the chart snippet and formula below.

       

       

       

       

       

      IF [# of Days to AAG Approval]<3 THEN "Excellent" ELSEIF [# of Days to AAG Approval]=3 THEN "Good" ELSE "Bad" END