B4J Tutorial [XLUtils] Conditional formatting

XLUtils v1.05 adds support for conditional formatting.


A conditional formatting element is made of the applied range and one or more rules. A rule is made of a formula and formatting effects.
The formula will be evaluated on each cell in the range. By using a relative address to the first cell in the formula, we are actually referencing all cells in range.

Adding conditional formatting is done in three steps:
1. Create one or more rules using Sheet.CreateConditionalFormattingRule.
2. Set the formatting effects.
3. Add the rules with Sheet.AddConditionalFormatting.

The attached example demonstrates several kinds of rules.


  • ConditionalFormatting.zip
    1.8 KB · Views: 303
Last edited: