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

[hanssaj]

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.

[Max]

I believe so.

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

Red
ifelse({color_condition}='RED',{color_condition},NULL)

Green
ifelse({color_condition}='Green',{color_condition},NULL)

Amber
ifelse({color_condition}='Amber',{color_condition},NULL)

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