Conditional formatting (color a row) based on values from another column in the dataset

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.

I believe so.

I think you would make three calculated fields for each color.




Then you would make three conditions based on each of the calculated fields.