addCondition(condition: ConditionalFormatObject)
[starting from version: 1.5]
Adds a conditional formatting rule for cell values to format them with specific styles if the condition for the cell value is met. Learn more in this guide: Conditional formatting.
Use refresh()
API call after to redraw the component and see changes.
Parameter/Type | Description |
---|---|
condition ConditionalFormatObject |
The object that describes the conditional formatting rule. |
1) If cell value is more than 400000
, then apply format
to this cell:
let condition = { id: 1, formula: '#value > 400000', format: { fontSize : "10px", backgroundColor: "#33BB33" } }; flexmonster.addCondition(condition); flexmonster.refresh();
Open the example on JSFiddle.
2) This rule will be applied only to the Price
measure's total and subtotal cells. If Price
is between 100000
and 1000000
, then the format
is applied:
let condition = { id: 2, measure: "Price", aggregation: "sum", isTotal: true, formula: 'AND(#value > 100000, #value < 1000000)', format: { fontSize : "11px", backgroundColor: "#00FF00" } }; flexmonster.addCondition(condition); flexmonster.refresh();
Check how it works on JSFiddle.
3) If cell value is empty, then apply format
to this cell:
let condition = { id: 1, formula: 'isNaN(#value)', format: { backgroundColor: "#FFFF11" } }; flexmonster.addCondition(condition); flexmonster.refresh();
Open the example on JSFiddle.
getCondition
getAllConditions
removeCondition
removeAllConditions
refresh
Conditional formatting tutorial