Forum Discussion

jleo25's avatar
jleo25
New Member
8 years ago
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....
  • Mond's avatar
    Mond
    8 years ago

    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.

Mond's avatar
Mond
Icon for Helper III rankHelper III
8 years ago

We don't have conditional formatting for Totals, but I can suggest to use high level table / matrix for the summation and make conditional format on the values.

Hope this help !