1 Reply Latest reply on Nov 6, 2018 7:38 AM by Sasha Hanna

    Conditional formating based on different variables and mesaures

    AJ.Yusuf

      Hi All I have this worksheet below. I have set colours for each mesure as indicated how ever I would like to change each colour conditional to the SALES Area. At the moment it is all set to one varible but I would to do this by each area therefore I can change the conditions

      I have tired to do a case statement

       

      for example say to say

      Area A then if crf% <=0.5 then "Red"

      Area B then crd%<=0.6 then "Red

      Area c the crf%<=0.7% the "red"

       

      Each of the measure will have a different conditon for each different area. Does anyone have any ideas