I am looking to do a conditional formatting in a matrix visualization based on a text column. Here is a sample below:
|Vendor ||Jan||Feb||March |
I've included the contract status (Contract / No Contract) and item description under the rows.
To provide a picture, there will be a plus(+) sign right next to the TMZ and STR. When you click it, it drills down to contract status and different items purchased from the vendor. The cumilative dollar amount is what you are seeing above. One might have purchased $20 worth of non contracted item and $80 worth of contracted item which brings the total to $100
I am looking to do a conditional formatting for the months where i should be able to see 80% (for contracted item purchases) green and 20% red (non contract purchases) keeping the dollar value same ($100).
IS there a way to do this ?
Thanks in advance