B4J Tutorial [XLUtils] Conditional formatting

XLUtils v1.05 adds support for conditional formatting.

1620309169007.png


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.
 

Attachments

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