2 Replies Latest reply on Dec 9, 2017 2:33 PM by Michelle Barrineau

    conditional formatting questions

    Michelle Barrineau

      Hi,

       

      I would really appreciate some help tweaking my conditional formatting.  Thanks to Hari Ankem, who got me this far!

      I would like to create three color groups.  One that is within 1% of my reference number, and one above and one below.

       

      Here is my latest attempt, which isn't working.

       

      IF  [Case % Change]< (-.1+ AVG([XAOC Percent])) THEN "Blue"

      ELSEIF [Case % Change]> (.1+ AVG([XAOC Percent])) THEN "Orange"

      Else "Green"

      END

       

      Thank you very much in advance!  This forum and the people that are helping make a huge difference to us beginners.

       

      Michelle B.