SetBorders

Sets the border style for the conditional formatting rule.

Syntax

expression.SetBorders(bordersIndex, lineStyle, oColor);

expression - A variable that represents a ApiFormatCondition class.

Parameters

Name	Required/Optional	Data type	Default	Description
bordersIndex	Required	BordersIndex		Specifies the cell border position.
lineStyle	Required	LineStyle		Specifies the line style used to form the cell border.
oColor	Required	ApiColor		The color object which specifies the color to be set to the cell border.

Returns

This method doesn't return any data.

Example

Add colored borders to cells that match a conditional formatting rule in a spreadsheet.

// How do I make matching cells show a border when a formatting condition is met in a spreadsheet?

// Highlight qualifying cells with edge lines through a conditional formatting rule in a spreadsheet.

let worksheet = Api.GetActiveSheet();

worksheet.GetRange("A1").SetValue("Sales Data");
worksheet.GetRange("A2").SetValue(100);
worksheet.GetRange("A3").SetValue(250);
worksheet.GetRange("A4").SetValue(150);
worksheet.GetRange("A5").SetValue(300);
worksheet.GetRange("A6").SetValue(75);

let dataRange = worksheet.GetRange("A2:A6");

let formatConditions = dataRange.GetFormatConditions();

let condition1 = formatConditions.Add("xlCellValue", "xlGreater", "200");
condition1.SetFillColor(Api.CreateColorFromRGB(255, 255, 0));

let borderColor = Api.CreateColorFromRGB(255, 0, 0);
condition1.SetBorders("Top", "Thick", borderColor);
condition1.SetBorders("Bottom", "Thick", borderColor);

worksheet.GetRange("C1").SetValue("Borders applied:");
worksheet.GetRange("C2").SetValue("Red thick top/bottom borders");