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.

[DefaultMember("Item")]
 public sealed class ConditionalFormat
<DefaultMember("Item")> _
	Public NotInheritable Class ConditionalFormat

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

ExcelApplication xla = new ExcelApplication();
Workbook wb = xla.Create();
ConditionalFormat cf = wb.CreateConditionalFormat();
Dim xla As New ExcelApplication()
Dim wb As Workbook = xla.Create()
Dim cf As ConditionalFormat = wb.CreateConditionalFormat()

Name

Description

Count

Range

Name

Description

Item(Int32)

Name

Description

CreateCondition(Comparison, String)

CreateCondition(Comparison, String, String)

RemoveCondition(Int32)

RemoveCondition(Condition)