cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Highlighted
Level 1

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions

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

Just done it with version 7

In state formatting selected statusstate and then given my parameters

Thank you all for replies...

6 REPLIES

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

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.

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

Check following link for more details on State Definition: PTC

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

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.

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

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

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

Just done it with version 7

In state formatting selected statusstate and then given my parameters

Thank you all for replies...

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

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