Conditonal colours

[#1]

=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?

[jerem1234 · Accepted solution]

if(wildmatch(Market, 'EMEA*'), RGB(141,90,162))

Hope this helps!