Alberto asked 7 years ago
Conditional cell css depending on the value of another cell.
I have to change the background color of one cell if the value of another cell in other column is X.
Both cells are is the same row.
Abu Ghufran answered 7 years ago
This is manually done via JS code. Refer demos/appearance/conditional-format-ext.php
Abu Ghufran answered 7 years ago
Code: http://phpgrid.org/demo/demos/appearance/conditional-format-ext.phps
Demo: http://phpgrid.org/demo/demos/appearance/conditional-format-ext.php
Alberto answered 7 years ago
Hello,
Thank you so much for the info.
It has been really handy.
I have another question.
I want to set the background in red of a field that has a negative amount in €,
there are a couple of field like that I want to do the same for all of them.
I am having problem at the time that the conditional CSS tries to recognize the – symbol in the field.
Any solution?
Thank you
Abu Ghufran answered 7 years ago
In JS code, you can remove € sign first e.g. string.replace('€','') and then use parseInt to get numeric variable, which can be used in conditional formatting code.
