Forum Discussion
Conditional Formatting in the Matrix
They are the subtotals (totals). They can be colored. Like below enable it in the settings:
Hi,
Please refer the image below. Using the Rules should work.
That worked i just dont understand whyn these numbers work. between -1000 < 1 red. Why does this work?
Also can this conditional formatting be applied to row headers as well?
Firstly, I recalled something that -1000 isn't necessary. We can use the built-in method as showing in the following image. Secondly, we can understand it this way: the conditional rules will iterate the value row by row. 123.44% is 1.2344 and it is greater than 1, then the background is green. The same logic for other values. Hope this helps. I am afraid we can't apply the background color to the header. Becuase the header is string other than numbers.
