GemBox.Spreadsheet Help

Class Library

GemBox.Spreadsheet

ExcelWorksheet Class

ExcelWorksheet Properties

BackgroundPictureFormat Property

BackgroundPictureStream Property

ConditionalFormatting Property

DataValidations Property

DefaultColumnWidth Property

DefaultRowHeight Property

EmbeddedObjects Property

Filter Property

FilterMode Property

HasHeadersFooters Property

HasSplitOrFreezePanes Property

HeadersFooters Property

HorizontalPageBreaks Property

Hyperlinks Property

IgnoredErrors Property

PrintOptions Property

Protected Property

ProtectedRanges Property

ProtectionSettings Property

Rows Property

SelectedRanges Property

VerticalPageBreaks Property

ViewOptions Property

Visibility Property

ExcelWorksheetConditionalFormatting Property

Gets the conditional formatting rules applied on cell ranges of this sheet.

Currently supported in XLSX only.

Namespace: GemBox.Spreadsheet
Assembly: GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 45.0.35.1084

Syntax

Copy

public ConditionalFormatRuleCollection ConditionalFormatting { get; }

Public ReadOnly Property ConditionalFormatting As ConditionalFormatRuleCollection
	Get

Property Value

Type: ConditionalFormatRuleCollection
The conditional formatting rules applied on cell ranges of this sheet.

Reference

ExcelWorksheet Class

GemBox.Spreadsheet Namespace

Other Resources

Excel Conditional Formatting example

ExcelWorksheetAddLanguageSpecificTextSet("LST627AE149_0?cpp=::|nu=.");ConditionalFormatting Property

Property Value

Reference

Other Resources

ExcelWorksheetConditionalFormatting Property