Cell background colour based on cell's value

[#1]

I have a Table Box object and one of the columns (Status) will always contain a string of either 'IN' or 'OUT'. I have gone into Custom Cell Formatting and attempted to change the background to a function like so:

IF([Status]='IN', LightBlue(), LightGreen())

But it only equates to true if ([Status]='IN' after selection, but I would like the fields to be colour coded without having to select anything. I thought fieldValue() might help me but wasn't sure how to use it.

Something like

IF(THISVALUE='IN', LightBlue(), LightGreen())

??

Thanks.

[Nicole-Smith · Accepted solution]

You can't do this on a table box.  You need to use a pivot or straight table, and then you can write an expression using the Background color on the dimension or expression:

[sureshbaabu]

That's right.. it's not possible in Table Box. You can achieve thro pivot or straight table views.

FYI... you can even use images in place of plain colors

Thanks

[nirav_bhimani]

Hi,

Its not possible through Table box, You can use straight table & Hide your expression,

Kindly find the attached file.

Regards,

Nirav Bhimani

[rwunderlich]

There is no need to create a hidden expression. When you have a straight table with Dimensions only, just uncheck "Suppress Zero Values" on the Presentation Pane.

-Rob

http://masterssummit.com

http://robwunderlich.com

[#6]

Hi George,

You can directly go to 'Chart Properties'  inside that 'Visual Cues', there you can directly set your range for Cell Background and Text colour also.

Thanks,

Shiven..

[#7]

Hi Nicole, Thanks for the solution, I have a slightly different requirement here. I have to color the cell in different shades between two colors (say red and blue) based on the cell value like in the below image.

is there any way to achieve this ?

[Shubham_Deshmukh]

failed to load