| SpreadJS Documentation > Developer's Guide > Customizing the Appearance > Using Conditional Formatting > Using the Formula Rule |
The formula rule allows you to use formulas when checking the condition.
This example creates a formula rule.
| JavaScript |
Copy Code
|
|---|---|
| var style = new GcSpread.Sheets.Style(); style.backColor = "red"; var rule =new GcSpread.Sheets.FormulaRule("=A1=B1+C1", style); rule.ranges = [new GcSpread.Sheets.Range(0, 0, 5, 1) ]; activeSheet.getConditionalFormats().addRule(rule); activeSheet.setValue(0, 0, 2,3); activeSheet.setValue(0, 1, 1,3); activeSheet.setValue(0, 2,1,3); activeSheet.setValue(1, 0, 1,3); |
|