I'm wondering if there's a way of doing some conditional css formation (changing background colour) of a cell based upon a different cell's value.
ie:
$fcol = array();
$fcol["column"] = "dataA";
$fcol["op"] = "eq";
$fcol["value"] = "abcdef";
$fcol["cellcss"] = "'background-color':'#99EBC2'";
That works fine for $dataA's value. I'm looking to modify dataA background based if $dataB eq "abcdef".
I could create a virtual column which is populated with a true/false and compare on that, but it seems a little convoluted.
1 Answers
You need to use advance conditional formatting code:
Sample: http://pastebin.com/PwHwdZKq
Your Answer