Forum Discussion
Make Totals on a Matrix Red if Negative
Hi,
We don't have conditional format on Totals.
Create another table of same structure with dept and final amount column next to the existing matrix.
Format Dept column to be hidden (may be column width to "2 points") and do conditional format on Final Amount column.
Microsoft EmployeeHi jleo25
Yes you can use conditional formatting. Click the down arrow of the field you would like to apply the conditional formatting to.
Then choose conditional formatting from the menu and then font colour scales
finally configure the conditional formatting dialog for your field as follows
Which should give you
That is how I got all of the other numbers to look how I wanted but it did not change the totals. Maybe I am missing something? I attached a pic of what I am working with, I have everything looking how I want except the totals.
MondHelper III
Hi,
We don't have conditional format on Totals.
Create another table of same structure with dept and final amount column next to the existing matrix.
Format Dept column to be hidden (may be column width to "2 points") and do conditional format on Final Amount column.
Thank you, that is what I was just trying to figure out after reading your 1st post. Thanks again