How to color Multivalued field in a dashboard xml?

[Cheng2Ready]

This is what I used
and after applying  the results just highlights the entire mv field in red

<format type="color">
<colorPalette type="expression"> case (match(value,"Large Effect"), "#ff0000",match(value,"Medium Effect"), "#ffff00",match(value,"Small Effect"),"#00ff00",true(),"#ffffff")</colorPalette>
</format>

looking for

Small effect -> Green
Medium effect -> Orange
and Large effect -> Red

Continuing from this search:
@ITWhisperer 
https://community.splunk.com/t5/Splunk-Search/How-to-extract-a-csv-data-fields-message-data-into-fie...

[ITWhisperer]

You will need to mvexpand the field for that you can colour rows of the field

[Cheng2Ready]

That worked!
but im trying to color the words " Large Effect " and "No"  to red
not sure what I did wrong here?

<colorPalette type="expression">case (match(value,"Large Effect") OR (match(value,"No"),"#ff0000",

match(value,"Medium Effect"), "#ffff00",match(value,"Small Effect"),"#00ff00",true(),"#ffffff")</colorPalette>

[ITWhisperer · Accepted solution]

Too many brackets - try like this

<colorPalette type="expression">case (match(value,"Large Effect") OR match(value,"No"),"#ff0000",match(value,"Medium Effect"), "#ffff00",match(value,"Small Effect"),"#00ff00",true(),"#ffffff")</colorPalette>