Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0
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#
Wiki Markup
{description}
{excerpt}A [ConditionalFormat|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|ConditionalFormat.Range] object representing the set of cells on which the conditions will be tested.{excerpt}
{signature:C#}
[DefaultMember("Item")]
 public sealed class ConditionalFormat
Signature
{signature}{signature:vb.net
vb.net
}
<DefaultMember("Item")> _
	Public NotInheritable Class ConditionalFormat
Remarks

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

{signature}
{remarks}To create a {{ConditionalFormat}}, call the [Workbook] object's [CreateConditionalFormat|Workbook.CreateConditionalFormat()] method.

{remarks}
{example}
{code:csharp|title=C#}
ExcelApplication xla = new ExcelApplication();
Workbook wb = xla.Create();
ConditionalFormat cf = wb.CreateConditionalFormat();
{code}
{code:vb.net
|title=vb.net
}
Dim xla As New ExcelApplication()
Dim wb As Workbook = xla.Create()
Dim cf As ConditionalFormat = wb.CreateConditionalFormat()
Example
Code Block
csharpcsharp
titleC#
Code Block
vb.nettitle
Properties

...

Name

...

Description

...

Count

...

{code}

{example}
{properties}
||Name||Description||
|[Count|ConditionalFormat.Count]|{excerpt-include:ConditionalFormat.Count

...

Range

|nopanel=true}|
|[Range|ConditionalFormat.Range]|{excerpt-include

...

:ConditionalFormat.Range

...

Indexers

...

Name

...

Description

|nopanel=true}|
{indexers}
||Name||Description||
|[Item(Int32)

...

|ConditionalFormat.Item(Int32)

...

]|{excerpt-include:ConditionalFormat.Item(Int32)

...

|nopanel

...

Methods

...

Name

...

Description

=true}|
{methods}
||Name||Description||
|[CreateCondition(Comparison, String)

...

|ConditionalFormat.CreateCondition(Condition.Comparison, String)

...

]|{excerpt-include:ConditionalFormat.CreateCondition(Condition.Comparison, String)

...

|nopanel

...

=true}|
|[CreateCondition(Comparison, String, String)

...

|ConditionalFormat.CreateCondition(Condition.Comparison, String, String)

...

]|{excerpt-include:ConditionalFormat.CreateCondition(Condition.Comparison, String, String)

...

|nopanel

...

=true}|
|[RemoveCondition(Int32)

...

|ConditionalFormat.RemoveCondition(Int32)

...

]|{excerpt-include:ConditionalFormat.RemoveCondition(Int32)

...

|nopanel

...

=true}|
|[RemoveCondition(Condition)

...

|ConditionalFormat.RemoveCondition(Condition)

...

]|{excerpt-include:ConditionalFormat.RemoveCondition(Condition)

...

|nopanel

...

=true}|