As shown in the screenshot, I have a pivot table where I have several columns in the “Rows” well and one column in the “Columns” well. This is my use case: if the value of the “Red” column is greater than 0 then I want to color the entire row red. If Red = 0 but Amber > 0 then I want to color the entire row orange, and if red = 0 and amber = 0 but green >0 then I want to color the row green.
Is this possible? If not please suggest some alternative! Thank you very much.