Colouring row subtotal backgrounds in a matrix

[AC23VM]

Hi there. I'm making a matrix with nested rows. One of the columns needs to show certain values as 1 of 3 colours. I used Cell Elements to apply a background colour rule to that column. However, the subtotals of the header rows (i.e., not the nested ones) don't change colours. I can change them all via Row Subtotals > Values, but this affects the whole row, and since you can't apply a rule, it can only be 1 colour. Anyone know if this is possible?

For context, here's a brief snip:

[Uzi2019]

Hi @AC23VM 

You cant apply the rules Neither in specific column formatting  Nor in Row subtotals..

You can only apply the rules in Cell Element setting.

we can apply to different color option but not a conditional formatting.

as you can see . 
Let me know if you need any help in this case.

I hope I answered your question!

[Bibiano_Geraldo]

Hi @AC23VM ,

You can change the color of subtotals by going to format pane, specific column and apply to subtotals as shown bellow:

This change the color for subtotals, but will be not dynamic.

[danextian · Accepted solution]

Hi @AC23VM 

Conditional formatting on row and column headers  is currently not supported, only for the values.