Forum Discussion
Solved
Make Totals on a Matrix Red if Negative
In my matrix I have all positive numbers black and all negative numbers red except for the totals. I have months as my column and departments as my lines, I have totals for both month and department....
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.
I had this same question then figured it out:
When you apply conditional formatting to the values themselves, you can select apply to Values and Totals in the UI