How to give background color to Cells that has no value in Pivot Table

[ramya_grandhi]

Hi All,

I have a pivot table in which some of the values are '0' and some values are nulls (-). My requirement is to give background color to the "empty cells" and also cells with '0' value.

Can anyone help me on this.

[Somasundaram]

Hi Ramya,

Measure properties, In back ground color expression,

=IF(sum(Field)<=0,RGB(123,123,123)) 

Provide correct RGB color.  Hope it will help.

[ramya_grandhi]

Hi Somasundaram,

Thanks for your reply,

My Pivot table is having positive, negative, 0 and null values. If I use Sum(Sales)<=0 it will color the negative values and 0 but not the empty cells.

[Somasundaram]

May be this
=IF(isnull(field) or sum(Field)<=0,RGB(123,123,123))