GrapeCity.Documents.Excel.IFormatCondition.Borders

Borders Property

Borders

Gets an instance of IBorders that represents the borders of this conditional format.

Use the returned border collection to access or modify the border settings stored on the conditional formatting rule.

Declaration

IBorders Borders { get; }

ReadOnly Property Borders As IBorders

Examples

worksheet.Range["A1:B5"].Value = new object[,] {{1, 2}, {0, 1}, {0, 0}, {0, 3}, {4, 5}};
IFormatCondition condition = (IFormatCondition) worksheet.Range["B1:B5"]
    .FormatConditions.Add(FormatConditionType.Expression, FormatConditionOperator.None, "=A1", null);
condition.Interior.Color = Color.Yellow;
IBorders borders = condition.Borders;
borders.Color = Color.Red;