How to condition format between two values

QuestionsHow to condition format between two values
David asked 11 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

4 Answers
Abu Ghufran answered 11 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 11 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 11 years ago

Can you please post this to my email as well. I have the recent build with me.

Abu Ghufran answered 11 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;

Your Answer

6 + 10 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?