XL.ConditionalFormat.SetBorder
------------------------------

Sets the border style.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [XL](component_XL.md) | [14.2](newinversion142.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "XL.ConditionalFormat.SetBorder"; BookRef; ConditionalFormatRef; Value ) 

**MBS**( **"XL.ConditionalFormat.SetBorder";** /\* Sets the border style. \*/  
**$BookRef**; /\* The reference number for the workbook.e.g. $ref \*/   
**$ConditionalFormatRef**; /\* The reference number for the conditional format.e.g. $ConditionalFormat \*/   
**$Value**) /\* The border style.  
Default value is 1 for thin.e.g. 1 \*/ 

### Parameters

| Parameter | Description | Example |
|---|---|---|
| BookRef | The reference number for the workbook. | $ref |
| ConditionalFormatRef | The reference number for the conditional format. | $ConditionalFormat |
| Value | The border style.   Default value is 1 for thin. | 1 |

### Result

Returns OK or error.

### Description

Sets the border style.  
Available styles:  
0 None  
1 Thin  
2 Medium  
3 Dashed  
4 Dotted  
5 Thick  
6 Double  
7 Hair  
8 Medium dashed  
9 Dash dot  
10 Medium dash dot  
11 Dash Dot Dot  
12 Medium dash dot dot  
13 Slant dash dot  
### Examples

Create border format:

 Set Variable \[$f ; Value:MBS ( "[XL.Sheet.AddConditionalFormatting](XLSheetAddConditionalFormatting.md)"; $book )\]  
Set Variable \[$r ; Value:MBS ( "XL.ConditionalFormat.SetBorder"; $book ; $f ; 1) // thin \]  
### See also

- [XL.ConditionalFormat.GetBorderLeft](XLConditionalFormatGetBorderLeft.md)
- [XL.ConditionalFormat.GetBorderTop](XLConditionalFormatGetBorderTop.md)
- [XL.ConditionalFormat.GetNumFormat](XLConditionalFormatGetNumFormat.md)
- [XL.ConditionalFormat.SetBorderBottom](XLConditionalFormatSetBorderBottom.md)
- [XL.ConditionalFormat.SetBorderLeft](XLConditionalFormatSetBorderLeft.md)
- [XL.ConditionalFormat.SetBorderRight](XLConditionalFormatSetBorderRight.md)
- [XL.ConditionalFormat.SetBorderTop](XLConditionalFormatSetBorderTop.md)
- [XL.ConditionalFormat.SetBorderTopColor](XLConditionalFormatSetBorderTopColor.md)
- [XL.ConditionalFormat.SetNumFormat](XLConditionalFormatSetNumFormat.md)
- [XL.Sheet.AddConditionalFormatting](XLSheetAddConditionalFormatting.md)

Created 30th March 2024 , last changed 11st May 2024

  
[XL.ConditionalFormat.GetPatternForegroundColor](XLConditionalFormatGetPatternForegroundColor.md) - [XL.ConditionalFormat.SetBorderBottom](XLConditionalFormatSetBorderBottom.md)

[HTML Version](XLConditionalFormatSetBorder.shtml)