Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=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?
if(wildmatch(Market, 'EMEA*'), RGB(141,90,162))
Hope this helps!