Changing the color of cell when specific value returned

[#1]

I have the Missing Symbol setup to display the value "N/A" and I want to make the cell change color when this value is returned. Is the reason why it won't change the color of the cell when the value is "N/A" because it represents a field that has returned no data? I am able to change the cell color when a number is returned as a value. I have this setup in an Expression under the Background Color Expression.

thanks,

Ryan

[johnw]

Sure. Here's an example.

[#3]

Great, thanks so much. My developer is working on implementing this!

[#4]

Hi everyone,

Is there a way to colour missing cells? I see that this topic shows how to colour the null values which i was aware of. however, the data for mine is definitely missing and not 'null'. Is it possible to do this?

Thanks,

[#5]

Furthermore,

In a pivot chart my subtotal is taking a colour value when i would like it to remain white. Any way around this?