Interface IPatternFormatting

High level representation for Font Formatting component of Conditional Formatting Settings.

Namespace: IronXL.Formatting

Assembly: IronXL.dll

Syntax

public interface IPatternFormatting

When a conditional formatting rule needs to fill the cells it matches, IPatternFormatting is the contract that sets that fill. It is the classic "color this cell when its value crosses a threshold" effect, the background color and pattern a rule paints over matched data, and the most common way a conditional rule draws attention. It is the fill side of conditional formatting, separate from the always-on fill on IStyle.

A developer obtains it from ConditionalFormattingRule.PatternFormatting, a get-only property on a rule created through a worksheet's conditional formatting surface. The fill applies only when the rule's condition is met, so it is configured on the rule before the rule is added to a region.

BackgroundColor sets the fill color as an RGB string, and FillPattern takes a FillPattern value for solid or patterned fills. A solid background color is the typical choice for highlighting; the pattern is there for cases that need a textured fill rather than a flat one.

using IronXL;
using IronXL.Formatting;

WorkSheet sheet = WorkBook.Load("report.xlsx").DefaultWorkSheet;
ConditionalFormattingRule rule = sheet.ConditionalFormatting
    .CreateConditionalFormattingRule(ComparisonOperator.GreaterThan, "1000");
rule.PatternFormatting.BackgroundColor = "#FFEB9C";

The conditional formatting how-to walks through building rules, and the background pattern color how-to covers fills and patterns directly.

Properties

BackgroundColor

Gets or sets the color of the background.

Declaration

string BackgroundColor { get; set; }

Property Value

Type	Description
System.String	The color of the background.

FillPattern

Gets or sets the fill pattern.

Declaration

FillPattern FillPattern { get; set; }

Property Value

Type	Description
FillPattern	The fill pattern.