May 5, 2021 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. Attachments ConditionalFormatting.zip ConditionalFormatting.zip 1.8 KB · Views: 755 Last edited: May 6, 2021 Click to expand...
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.
