Message-ID: <558352156.9055.1711674658654.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_9054_653209660.1711674658654" ------=_Part_9054_653209660.1711674658654 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html ConditionalFormat

ConditionalFormat

Description

=20

A ConditionalFormat obje= ct 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 Conditi= on and a Range ob= ject representing the set of cells on which the conditions will be tested.<= /p>=20

C#
=20
[DefaultMember("Item")]
 public sealed class ConditionalFormat
=20
=20
vb.net
=20
<DefaultMember("Item")> _
=09Public NotInheritable Class ConditionalFormat
=20
=20

Remarks

To create a=20 ConditionalFormat, call the=20 Workbook object's= =20 Create= ConditionalFormat method.=20

Examples

=20
C#
=20
ExcelApplication xla =3D new ExcelApplication();
Workbook wb =3D xla.Create();
ConditionalFormat cf =3D wb.CreateConditionalFormat();
=20
=20
vb.net
=20
Dim xla As New ExcelApplication()
Dim wb As Workbook =3D xla.Create()
Dim cf As ConditionalFormat =3D wb.CreateConditionalFormat()
=20
=20

Properties

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

Name

Description

Count

Returns the number of Condition objects in the current ConditionalFormat object.

Range

Returns the Range of cells that is conditionally formatted by the cur= rent ConditionalFormat obje= ct.
=20

Indexers

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20

Name

Description

Item(Int32)

Returns the = Condition object at the specified 0-based index.
=20

Methods

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

Name

Description

CreateCondition(Comparison, String)

Creates a Co= ndition of the specified ComparisonType.

CreateCondition(Comparison, String, String)

Creates a Co= ndition of the specified ComparisonType.

RemoveCondition(Int32)

Removes the = Condition at the specified index from the conditional format.

RemoveCondition(Condition)

Removes the specified Condition from the ConditionalFormat object.
------=_Part_9054_653209660.1711674658654--