Background Color for Null Data in Pivot Table

[Anonymous]

Hi! Is it possible to give background color for null data?

I would like to give condition like: If month> Apr 2015, then LightCyan, else light magenta. this is as far as I can get.

[Gysbert_Wassenaar]

Turn on the Design Grid in the View menu. Then right click on of the cells and choose the option Custom Format Cell. Then click on the Background Color button and change the background color.

[Anonymous]

hi thanks! but I want to give a condition like:

If month>= Apr 2015, then LightCyan, else light magenta.

I tried to use this expression in calculated box:

if(MonthYear>'Mar-2015',LightCyan(),magenta())

It only give me magenta color.

What am i doing wrong?

[vishsaggi]

Can you uncheck Supress 0 values in presentation tab of your chart properties and see if that helps.  Are you looking something like below:

[Anonymous]

No. I need all values before may 2015 to be Magenta, and after apr 2015 to be lightcyan.

But I cannot get the correct formula for it