Forum Discussion
Helper IIColouring row subtotal backgrounds in a matrix
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:
3 Replies
- Bibiano_Geraldo
Super User
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.
Uzi2019Community Champion
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!
