GrapeCity.Documents.Excel.IFormatConditions.Count

Count Property

Count

Gets the number of objects in the collection.

This collection contains the conditional formats associated with a range.

Declaration

int Count { get; }

ReadOnly Property Count As Integer

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;
IFormatCondition condition1 = (IFormatCondition)range.FormatConditions.Add(FormatConditionType.Expression, FormatConditionOperator.None, "=A1>6", null);
condition1.Interior.Color = Color.LightBlue;
int count = range.FormatConditions.Count;