Forum Discussion
Conditional formatting expense vs income
Dear PBI community,
I am currently using conditional formatting in a matrix column on difference % of actuals vs budget. I am using the standard conditional formatting future stating -1 (-100%) is red and 1 (100) is green. However, i would like to distinguish between income and expense rows, so that for expense the opposite is true (-1 is green and 1 is red).
Would be great if any of you would have a solution for this.
KR,
Khalid
1 Reply
I don't think this is a good idea, that you have in the same column data of green and red color and at the same time 70% can be green and on the line below 70% is red. I think you should rather distinguish it. From my point of view it is not user friendly approach at all..
