Change background color of a grid based on individual element value

Hi,


Im using ActiveWidgets version 2.5.5. The values required by the grid are provided in a .csv file which is already preprocessed. I'm trying to colour individual elements based on the values obtained from the .csv file.

How do i go about doing this? Any help would be appreciated.

This applies to rows :
http://www.activewidgets.com/javascript.forum.10823.5/b4-bug-when-coloring-a.html
And you can do the same for cells:
<script>
var obj = new AW.UI.Grid;
obj.setCellData(function(col, row){return col + "." + row});
obj.setHeaderText("header");

obj.setColumnCount(10);
obj.setRowCount(10);

obj.setCellEditable(true);

// add new cell property for background color
obj.defineCellProperty("bgColor", function(col, row){

// lets say we check the text from any cell
var text = this.getCellText(col, row);

var cellColor = 'none';
if (text < 2) {
cellColor = "#00FF00";
}
if (text > 4) {
cellColor = "red";
}
if (text >= 200){
if (text <=450){
cellColor = "yellow";
}
}
return cellColor;
});

// assign rowBackground to row template style
obj.getCellTemplate().setStyle("background", function(){
return this.getCellProperty("bgColor");
});

obj.onCellValidated = function(text, col, row){
var template = this.getCellTemplate(col,row);
setTimeout(function(){
template.setStyle("background", template.getCellProperty("bgColor"));
}, 150);
}

document.write(obj);
</script>