Basic column conditional formatting with pattern match / "contains" operator

3276546

Hi,

I'm trying to set a conditional format on a column if it contains some text. Is this possible? The GUI does not give "Contains All" or "Contains Any" as an operator.

Solutions I have tried and failed:

- Creating a second column to base the condition on (e.g. case when X contains Y then 1 else 0 end). The field is the measure of a pivot table and so a second column will not work.

- Editing the XML. I tried changing the code from <sawx:expr xsi:type="sawx:comparison" op="equal"> to  <sawx:expr xsi:type="sawx:list" op="containsAll"> but no luck.

Is there a different XML format or another way to do this?