Pivot Table Formatting

[evansabres]

Hello -

I have a pivot table that shows available tickets for different sections of an arena. My chart appears as this:

I want to have the cells formatted, similar to a heat map. Is this possible? I would like to have the cell appear purple if more than 100 tickets remaining and orange if less than 100.

Thank you.

[sunny_talwar · Accepted solution]

If you should be able to use background color expression to do this:

If(YourExpression > 100, RGBforPurple, RGBforOrange)

[evansabres]

thank you

[rubenmarin]

Hi, I also use:

If(ExpressionLabel> 100, RGBforPurple, RGBforOrange)

This way if the expression changes the backgroundcolor will apply the modified expression without requiring any changes (althought it needs manually maintenance if expression label changes)

Not sure if this uses the already calculated value (wich should give better performance) or recalculates the expression.