3 Replies Latest reply on Oct 8, 2018 3:06 PM by Nick Parsons

    Color columns based on weeks

    Harjeet kaur

      I need to color columns based on the weeks. picture below show how I have my 4 weeks in the  columns and target 

       

      so 07-oct would be week 1 , 14-oct week 2 etc.. these 4 weeks change

       

      % of supply needed per week:

       

       

      what i am trying to do is color week 1 if met 95%, color week 2 if met 70% , week 3 if met 25%, week 4 if met 15%  (so for index 1 07-oct week 1 22/24.2 = 91% so the column wont be color, but index 2 would be color for 7-oct as its 31/27.4= 114%)