SpreadJS Documentation
NormalConditionRule Method
GC.Spread.Sheets Namespace > ConditionalFormatting type : NormalConditionRule Method
The cell ranges where the rule is applied whose item type is GC.Spread.Sheets.Range.
The style that is applied to the cell when the condition is met.
The comparison operator.
The first value.
The second value.
The text for comparison.
The condition formula.
The average condition type.
The number of top or bottom items to apply the style to.
Represents a normal conditional rule.
Syntax
var value; // Type: any
value = GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule(ruleType, ranges, style, operator, value1, value2, text, formula, type, rank);
function NormalConditionRule( 
   ruleType : RuleType,
   ranges : undefined,
   style : Style,
   operator : object,
   value1 : object,
   value2 : object,
   text : string,
   formula : string,
   type : object,
   rank : number
) : any;

Parameters

ruleType
ranges
The cell ranges where the rule is applied whose item type is GC.Spread.Sheets.Range.
style
The style that is applied to the cell when the condition is met.
operator
The comparison operator.
value1
The first value.
value2
The second value.
text
The text for comparison.
formula
The condition formula.
type
The average condition type.
rank
The number of top or bottom items to apply the style to.
Example
activeSheet.setArray(0,0,[1,2,3,4,5,6,7,8,9,10]);
var cell = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule();
cell.ruleType(GC.Spread.Sheets.ConditionalFormatting.RuleType.cellValueRule);
cell.operator(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.greaterThan);
cell.value1(5);
cell.ranges([new GC.Spread.Sheets.Range(0, 0, 10, 1)]);
var style = new GC.Spread.Sheets.Style();
style.backColor = "red";
cell.style(style);
activeSheet.conditionalFormats.addRule(cell);
//button
$("#button1").click(function () {
     cell.reset();
     activeSheet.suspendPaint();
     activeSheet.resumePaint();
});
See Also

Reference

ConditionalFormatting type