Using the Cell Value Rule

The cell value rule compares values.

This example creates a cell value rule.

JavaScript	Copy Code
var style = new GcSpread.Sheets.Style(); style.backColor = "red"; var rule = new GcSpread.Sheets.CellValueRule(GcSpread.Sheets.ComparisonOperator.Between,2,100,style); rule.ranges=[new GcSpread.Sheets.Range(0,0,5,1)]; activeSheet.getConditionalFormats().addRule(rule); activeSheet.setValue(0,0,1,3); activeSheet.setValue(1,0,45,3);