Page History

{description}
{excerpt}Removes the [Condition] at the specified index from the conditional format.{excerpt}
{signature:C#}
 public void RemoveCondition(int index)
{signature}{signature:vb.net}
Public Sub RemoveCondition(ByVal index As Integer)
{signature}
{parameters}
{param:index}The 0\-based index of 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(0);
        {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(0)
        {code}

{example}