Forum Discussion
Solved
Conditional Formatting in the Matrix
I am trying to put some background colors in the values of my matrix. I have column called "Achieved" with following values 123.44% 87.22% 146% which means 23.44 above the target 12.78 b...
They are the subtotals (totals). They can be colored. Like below enable it in the settings:
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.