| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
XL.Sheet.ConditionalFormatting
Returns conditional formatting rules with the specified index (only for xlsx files).
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| XL | 16.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "XL.Sheet.ConditionalFormatting"; BookRef; SheetIndex; Index ) More
Parameters
| Parameter | Description | Example |
|---|---|---|
| BookRef | The reference number for the workbook. | $ref |
| SheetIndex | The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. | 0 |
| Index | The index from 0 to size-1. | 0 |
Result
Returns ConditionalFormattingRef or error.
Description
Returns conditional formatting rules with the specified index (only for xlsx files).The index must be less than the return value of the XL.Sheet.ConditionalFormatSize function.
This translates from counting up index to the indexes we use to refer to conditional formats.
See also
- XL.Book.ConditionalFormatSize
- XL.Book.SheetCount
- XL.Sheet.AddConditionalFormatting
- XL.Sheet.ConditionalFormatSize
- XL.Sheet.RemoveConditionalFormatting
Release notes
- Version 16.1
- Added XL.Sheet.ConditionalFormatSize and XL.Sheet.ConditionalFormatting functions.
Blog Entries
Created 20th January 2026, last changed 20th January 2026
