# SpreadsheetFormatColumns

Formats multiple columns of an Excel spreadsheet object.

## Method Signature

```
SpreadsheetFormatColumns(spreadsheetObj=[any], format=[any], columns=[any])
```

### Arguments

| Argument         | Type     | Required | Description                                                                                                                                                                                                       | Default |
| ---------------- | -------- | -------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------- |
| `spreadsheetObj` | `ANY`    | `true`   | The spreadsheet object.                                                                                                                                                                                           |         |
| `format`         | `STRUCT` | `true`   | A structure containing formatting options (bold, italic, color, etc.).                                                                                                                                            |         |
| `columns`        | `STRING` | `true`   | The columns to format, in one of the following formats: \* - startColumn-endColumn for a range (e.g., "1-5") \* - column,column,column for individual columns (e.g., "1,3,5") \* - combinations like "1-3,5,7-10" |         |

## Examples

Format multiple columns:

```js
// Format columns 2-4 with same style
var spreadsheet = SpreadsheetNew();
var format = { alignment = "right", numFmt = "$#,##0.00" };
SpreadsheetFormatColumns( spreadsheet, 2, 3, format );
```

## Related

* [SpreadsheetFormatColumn()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetformatcolumn) - Format single column
* [SpreadsheetFormatRows()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetformatrows) - Format rows