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
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 Name Description Name Description Name DescriptionConditionalFormat 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
[DefaultMember("Item")]
public sealed class ConditionalFormat
=20
<DefaultMember("Item")> _
=09Public NotInheritable Class ConditionalFormat
=20
Remarks
To create a=20
ConditionalFormat
, call the=20
Workbook object's=
=20
Create=
ConditionalFormat method.=20
Examples
=20
ExcelApplication xla =3D new ExcelApplication();
Workbook wb =3D xla.Create();
ConditionalFormat cf =3D wb.CreateConditionalFormat();
=20
Dim xla As New ExcelApplication()
Dim wb As Workbook =3D xla.Create()
Dim cf As ConditionalFormat =3D wb.CreateConditionalFormat()
=20
Properties
=20
=20
=20
=20
=20
=20
=20
=20
=20
Returns the number of Condition objects in the current ConditionalFormat object. =20
=20
=20
=20
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
Returns the =
Condition object at the specified 0-based index. =20
Methods
=20
=20
=20
=20
=20
=20
=20
=20
=20
Creates a Co=
ndition of the specified ComparisonType. =20
=20
=20
=20
Creates a Co=
ndition of the specified ComparisonType. =20
=20
=20
=20
Removes the =
Condition at the specified index from the conditional format. =20
=20
=20
=20
Removes the specified Condition from the ConditionalFormat object. =20