var scale = new GC.Spread.Sheets.ConditionalFormatting.ScaleRule(); scale.ruleType(GC.Spread.Sheets.ConditionalFormatting.RuleType.threeScaleRule); scale.midColor("red"); scale.midType(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number); scale.midValue(50); scale.maxColor("blue"); scale.maxType(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number); scale.maxValue(100); scale.minColor("yellow"); scale.minType(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number); scale.minValue(10); scale.ranges([new GC.Spread.Sheets.Range(0, 0, 10, 3)]); activeSheet.conditionalFormats.addRule(scale); activeSheet.setValue(0,0, 1,3); activeSheet.setValue(1,0, 50,3); activeSheet.setValue(2,0, 100,3);
activeSheet.conditionalFormats.add2ScaleRule(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number,1,"Yellow",GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number,50,"Blue", [new GC.Spread.Sheets.Range(0,0,20,1)]); activeSheet.setValue(0,0,1,3); activeSheet.setValue(1,0,45,3); activeSheet.setValue(2,0,75,3);