David asked 10 years ago
Hi!
I just purchased this awesome lib today.
I have a litte question.
I'm working with prices columns and I want to format cells colors comparing two prices.
For example, I have Price1 and Price2 columns so I want to format Price 2 cell color if Price1 value is greater than Price1.
How can I do this trick?
Thank you in advance!
Regards
Abu Ghufran answered 10 years ago
Hello,
Using column value in conditional formatting condition need a minor update.
I'll be emailing you this build in another thread.
David answered 10 years ago
Hello Abu,
Just received the update and now is working great!
Thank you very much for your time and congratulations for this great script!!
Best regards!
Ananda Theerthan answered 10 years ago
Can you please post this to my email as well. I have the recent build with me.
Abu Ghufran answered 10 years ago
If you have latest build you can use this formatting condition.
I am also emailing you sample.
$f = array();
$f["column"] = "id";
$f["op"] = "<";
$f["value"] = "{jid}"; // you can use placeholder of column name as value
$f["cellcss"] = "'background-color':'teal'";
$f_conditions[] = $f;
