Wiki Markup |
---|
{description} {excerpt}Removes the specified [Condition] from the [ConditionalFormat|ConditionalFormat] object.{excerpt} {signature:C#} public void RemoveCondition(Condition condition) {signature}{signature:vb.net} Public Sub RemoveCondition(ByVal condition As Condition) {signature} {parameters} {param:condition}The [Condition|Condition] object to remove.{param} {example}{code: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(cond2); {code} {code: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(cond2) {code} {example} |
Page History
Overview
Content Tools