Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Description

Excerpt

A ConditionalFormat object represents a conditional format that Excel will apply to a cell or group of cells if a specified condition is met. Each ConditionalFormat object contains up to three Condition and a Range object representing the set of cells on which the conditions will be tested.

Signature
C#
C#
[DefaultMember("Item")]
 public sealed class ConditionalFormat
{signature}{signature:
}
Signature
vb.net
vb.net
<DefaultMember("Item")> _
	Public NotInheritable Class ConditionalFormat
{signature}
{remarks}To create a {{ConditionalFormat}}, call the [Workbook] object's [CreateConditionalFormat|Workbook.CreateConditionalFormat()] method.

{remarks}
{example}
{code:csharp|title=C#}
Remarks

To create a ConditionalFormat, call the Workbook object's CreateConditionalFormat method.

Example
Code Block
csharp
csharp
titleC#

ExcelApplication xla = new ExcelApplication();
Workbook wb = xla.Create();
ConditionalFormat cf = wb.CreateConditionalFormat();
{code} {code:
Code Block
vb.net
|title=
vb.net
titlevb.net
}

Dim xla As New ExcelApplication()
Dim wb As Workbook = xla.Create()
Dim cf As ConditionalFormat = wb.CreateConditionalFormat()
{code} {example} {properties} ||Name||Description|| |[Count|ConditionalFormat.Count]|{excerpt-include:ConditionalFormat.Count|nopanel=true}| |[Range|ConditionalFormat.Range]|{excerpt-include:ConditionalFormat.Range|nopanel=true}| {indexers} ||Name||Description|| |[Item(Int32)|
Properties

Name

Description

Count

Excerpt Include
ConditionalFormat.Count
ConditionalFormat.Count
nopaneltrue

Range

Excerpt Include
ConditionalFormat.Range
ConditionalFormat.Range
nopaneltrue
Indexers

Name

Description

Item(Int32)

Excerpt Include
ConditionalFormat.Item(Int32)

...

ConditionalFormat.Item(Int32)

...

nopanel

...

true
Methods

...

...

Excerpt Include
ConditionalFormat.CreateCondition(Condition.Comparison,

...

String)

...

ConditionalFormat.CreateCondition(Condition.Comparison,

...

String)

...

nopanel

...

...

...

...

Excerpt Include
ConditionalFormat.CreateCondition(Condition.Comparison,

...

String,

...

String)

...

ConditionalFormat.CreateCondition(Condition.Comparison,

...

String,

...

String)

...

nopanel

...

...

Excerpt Include
ConditionalFormat.RemoveCondition(Int32)

...

ConditionalFormat.RemoveCondition(Int32)

...

nopanel

...

...

Excerpt Include
ConditionalFormat.RemoveCondition(Condition)

...

ConditionalFormat.RemoveCondition(Condition)

...

nopanel

...

true

...