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.
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.
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:
It only give me magenta color.
What am i doing wrong?