XlCondFmtRuleWithFormatting.Formatting Property

Provides access to a set of formatting properties applied to cells when the status of the conditional formatting rule is true.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public XlDifferentialFormatting Formatting { get; set; }

VB.NET

Public Property Formatting As XlDifferentialFormatting

Property Value

Type	Description
DevExpress.Export.Xl.XlDifferentialFormatting	A DevExpress.Export.Xl.XlDifferentialFormatting object representing the available formatting properties.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Formatting property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

excel-export-api-examples/CS/XLExportExamples/SpreadsheetActions/ConditionalFormattingActions.cs#L209

// Specify formatting settings to be applied to cells if the condition is true.
rule.Formatting = XlCellFormatting.Bad;
formatting.Rules.Add(rule);

VB.NET

excel-export-api-examples/VB/XLExportExamples/SpreadsheetActions/ConditionalFormattingActions.vb#L208

' Specify formatting settings to be applied to cells if the condition is true.
rule.Formatting = XlCellFormatting.Bad
formatting.Rules.Add(rule)