Can we update a cell color of a grid on basis of its value

[kborkar]

I have my data in data table and i am displaying that in grid in mashup.

Can i update particular cell color on basis of its value.

for example,

if cell contains value 'ON' than that cell should be displayed with green color.

And if cell contains value 'OFF' than that cell should be displayed with red color.

[ankigupta]

Hi Kedar Borkar​, Yes That's possible.

Just click on the drop down icon on the top left of the Grid.

Then configure the Column containing ON OFF details.

Go to Column Renderer & State Formatting Tab and select State-based Formatting

Set the dependent field as your column.

Set the State Definition. You might have to create one if you haven't already that defines the state and color.

I Hope it helps.

[ankigupta]

Check following link for more details on State Definition: PTC

[kborkar]

Already Tried with state formatting but not able to place condition actually i have two values and basis on that i want to change color.

But its displaying that color in every cell of that column.

[LaurentGermain]

Doesnt work for me: it always use the default style, and not the one associated to text values

[nbansal]

Hello Kedar, which version of Thingworx are you working on?

[kborkar · Accepted solution]

Just done it with version 7

In state formatting selected statusstate and then given my parameters

Thank you all for replies...