Page History

Description

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

Signature

	C#
	C#

 public void RemoveCondition(int index)

Signature

	vb.net
	vb.net

Public Sub RemoveCondition(ByVal index As Integer)

Parameters

Param

	index
	index

The 0-based index of the Condition object to remove.

Example

Code Block

	csharp
	csharp
title	C#


          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          ConditionalFormat condFmt = wb.CreateConditionalFormat();
          Condition cond1 =
               condFmt.CreateCondition(
               Condition.Comparison.CellValueBetween,
               "=100",
               "=150");
          Condition cond2 =
               condFmt.CreateCondition(
               Condition.Comparison.CellValueGreaterThan,
               "=100");
          condFmt.RemoveCondition(0);

Code Block

	vb.net
	vb.net
title	vb.net


          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Create()
          Dim  condFmt As ConditionalFormat = wb.CreateConditionalFormat()
          Dim cond1 As Condition = _
               condFmt.CreateCondition( _
               Condition.Comparison.CellValueGreaterThan, _
               "=100")
          Dim cond2 As Condition = _
               condFmt.CreateCondition( _
               Condition.Comparison.CellValueBetween, _
               "=100", _
               "=150")
          condFmt.RemoveCondition(0)

Space Shortcuts

Page tree

Versions Compared

Old Version 1

New Version Current

Key