SpreadJS Documentation
NormalConditionRule class
GC.Spread.Sheets.ConditionalFormatting Namespace : NormalConditionRule class
Represents a normal conditional rule.
Syntax
var instance = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule(ruleType, ranges, style, operator, value1, value2, text, formula, type, rank);
function NormalConditionRule;
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();
});
Inheritance Hierarchy

Object
   GC.Spread.Sheets.ConditionalFormatting.ConditionRuleBase
      GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule

Constructors
 NameDescription
public ConstructorRepresents a normal conditional rule.  
Top
Methods
 NameDescription
public Method (Inherited from GC.Spread.Sheets.ConditionalFormatting.ConditionRuleBase)
public Method (Inherited from GC.Spread.Sheets.ConditionalFormatting.ConditionRuleBase)
public MethodCreates a condition for the rule.  
public Method (Inherited from GC.Spread.Sheets.ConditionalFormatting.ConditionRuleBase)
public MethodGets or sets the condition formula.  
public Method (Inherited from GC.Spread.Sheets.ConditionalFormatting.ConditionRuleBase)
public Method (Inherited from GC.Spread.Sheets.ConditionalFormatting.ConditionRuleBase)
public Method (Inherited from GC.Spread.Sheets.ConditionalFormatting.ConditionRuleBase)
public MethodGets or sets the comparison operator.  
public Method (Inherited from GC.Spread.Sheets.ConditionalFormatting.ConditionRuleBase)
public Method (Inherited from GC.Spread.Sheets.ConditionalFormatting.ConditionRuleBase)
public MethodGets or sets the number of top or bottom items to apply the style to.  
public MethodResets the rule.  
public Method (Inherited from GC.Spread.Sheets.ConditionalFormatting.ConditionRuleBase)
public Method (Inherited from GC.Spread.Sheets.ConditionalFormatting.ConditionRuleBase)
public Method (Inherited from GC.Spread.Sheets.ConditionalFormatting.ConditionRuleBase)
public MethodGets or sets the text for comparison.  
public MethodGets or sets the average condition type.  
public MethodGets or sets the first value.  
public MethodGets or sets the first value.  
Top
See Also

Reference

GC.Spread.Sheets.ConditionalFormatting Namespace
Using Conditional Formatting