Spread.Sheets 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 Method  
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 Method  
public Method  
Top
See Also

Reference

GC.Spread.Sheets.ConditionalFormatting Namespace
Using Conditional Formatting