conditional formatting in matrix based on a different text field

Hi sjain6,

According to my understanding, you want the matrix to highlight some specific cells based on one column value, right? Unfortunately, this is not supported now. The conditional formatting option provides a color scale, that paints the cell with gradient.

In your scenario, if the matrix only contains two values, 0 and 1, to highlight the cell which has value 0, you can configure conditional formatting like below:

Reference: Conditional formatting based on dynamic values

Best regards,
Yuliana Gu

Hello sjain6,

Lucky you, there is a simple trick to work around the limitation. You can use conditional formatting on value columns in matrices having a numeric value. Therefore you need a measure or field, which will be used for this column.

1. Convert the text status field into numbers. Better to use a field instead of a measure, but that's not that important. So you have 0 for "expired" and null for the rest
2. Add the new field to the matrix
3. Set up conditional formatting on this field. E.g. use background color scales for ranges. There set the conditions to match 0 with the desired color.

And that's it.

See the example below: