1 Reply Latest reply: Jul 3, 2014 11:27 AM by Jeremiah Kurpat RSS

    Conditonal colours

      =IF(Market='EMEA*',RGB(141,90,162),)

       

      wildcarding the MARKET field doesn't seem to work when I am trying to conditionally colour some bars in my chart.

       

      What i need to do is colour all values which start with 'EMEA'. I don't want to have to do a nested if statement for all possible values.

       

      How can I amend my formula to do this?