GrapeCity.Documents.Excel.IFormatConditions.Delete

Delete Method

Delete()

Deletes all conditional formats associated with the represented range.

Use this method to remove every conditional formatting rule from the range's IFormatConditions collection.

Declaration

void Delete()

Sub Delete()

Examples

IRange range = worksheet.Range["A1:A5"];
range.Value = new object[,] {{1}, {3}, {5}, {7}, {9}};
IFormatCondition condition = (IFormatCondition)range.FormatConditions.Add(FormatConditionType.CellValue, FormatConditionOperator.Between, 1, 5);
condition.Interior.Color = Color.Yellow;
range.FormatConditions.Delete();