Page History

Description

Excerpt
Creates a new ConditionalFormat object that can be set on Cells, Areas and Ranges.

Signature
C#	C#
Wiki Markup
{description} {excerpt}Creates a new [ConditionalFormat] object that can be set on [Cell]s, [Area]s and [Range]s. {excerpt} {signature:C#} public ConditionalFormat CreateConditionalFormat()
Signature
{signature}{signature:vb.net	vb.net	} Public Function CreateConditionalFormat() As ConditionalFormat

Returns
A `ConditionalFormat` object representing a conditional format that Excel will apply to a cell or group of cells if a specified condition is met.

Remarks
A Cell, Area or Range object holds its own copy of the ConditionalFormat when set; changes made to a `ConditionalFormat` after it is set will not affect the copies.

{signature}
{returns}A {{ConditionalFormat}} object representing a conditional format that Excel will apply to a cell or group of cells if a specified condition is met.{returns}
{remarks}
A [Cell|Cell], [Area|Area] or [Range|Range] object holds its own copy of the [ConditionalFormat|ConditionalFormat] when set; changes made to a {{ConditionalFormat}} after it is set will not affect the copies.
{remarks}
{example}{code:csharp|title=C#}
wb.CreateConditionalFormat();

{code}
{code:vb.net

|title=vb.net

}
wb.CreateConditionalFormat(){code}

{example}

Example

Code Block
csharp	csharp
title	C#
Code Block
vb.net	title

Space Shortcuts

Page tree

Versions Compared

Old Version 1

New Version 2

Key