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

    conditional formatting questions

    Michelle Barrineau



      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"



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


      Michelle B.