2 Replies Latest reply on Feb 11, 2019 7:00 AM by Chris Ford

    Conditional Format (Individ

    Chris Ford

      Hello!

       

      Im trying to colour individual measures based on their values and struggling. I have tried the AGG process but cant seem to get it to work.

       

      In summary, this is what Im trying to achieve.

       

      3 - Actual Total Complete is coloured green if its more than 2 - Planned Complete

      else

      3 - Actual Total Complete is coloured red if its less than 2 - Planned Complete

       

      The other bars can stay blue and grey.

       

      Attached package workbook below if anyone can help me.

       

      TenderImage.jpg