Conditional format in pivot table

[Anonymous]

Hi,

I have pivot table if category is empty i want to display the entire column into red color. I wrote expression in background color but it repeats the colors in all empty cells.

Here category is empty and highlighted rows only red color will appear. Could you please help to achieve this.

Regards,

Yuvaraj G

[leonardo_alexsa]

Good afternoon.

Try to do this:

=If(Sum(SALES) = 0, RGB(237,28,36))

Change SALES to your Metric.

[Digvijay_Singh]

May be this -