Conditional Cell Formatting

[mikep]

Disregard my last request. At the moment I don't need to apply this grouping granularity. Thanks again.

[mikep]

For grouped rows: I would like to change the background of the grouping row to red if two particular columns are not equal AND if the group row is grouped by a particular column.
In my jsfiddle, if month1 <> month 2 AND is grouped by Rank, then color red.

https://jsfiddle.net/z3w2Lthc/

[paramvir]

Code: [Select]

rowInit: function(ui) {
  var rd = ui.rowData;
  if (rd.pq_gtitle) {
    if ((rd.month1 != rd.month2) && (this.option('groupModel.dataIndx').indexOf('rank') >= 0))
      return {
        style: 'background:red;'
      }
    else
      return {
        style: 'background:#ff9812;'
      }
  }
},

https://jsfiddle.net/nmyj7ezh/2/

[mikep]

Thank you. What is the syntax If I only want to color 1 column (month1) red in the grouping row? I tried a render function for the column but could figure out the group logic.

[paramvir]

Same syntax.

move same code to column.render callback:

https://jsfiddle.net/4sfkjn90/

[mikep]

Thanks! Follow on question. Now that I've applied a cell color, the red tracking indicator no longer appears after the cell is edited. The grid still remembers the edited rows, but the indicator doesn't display. Adding this callback makes the "dirty" indicator not appear. Any ideas?

colAP.render = function (ui) {
  return { style: 'background:pink' };
}

Here's an example that mimics my layout, but in this example the indicator DOES appear. Hopefully you may have an idea.
http://jsfiddle.net/vydnwLoa/6/

[paramvir]

Please use 'background-color' instead of background.

[mikep]

Thank you. How can I color column headers dynamically? In the example below, I'd like the column headers (both rows) colored the same as the cells.

https://jsfiddle.net/mc95f4d0/3/

[mikep]

Hello, will you be able to address this in the next day or 2?

[paramvir]

Sorry, header cells can't be dynamically styled.