Platforms to show: All Mac Windows Linux Cross-Platform

XLConditionalFormatMBS class   New in 24.2

Type Topic Plugin Version macOS Windows Linux iOS Targets
class XL MBS XL Plugin 24.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The class for a format used with conditional formatting.
// highlighting alternating rows
book.RgbMode = true

Dim cFormat As XLConditionalFormatMBS = book.addConditionalFormat()
cFormat.FillPattern = cFormat.FillPatternSolid
cFormat.PatternBackgroundColor = book.PackColor(240, 240, 240)

Dim cFormatting As XLConditionalFormattingMBS = sheet.addConditionalFormatting()
cFormatting.addRange(4, 20, 1, 10)
cFormatting.addRule(cFormatting.FormatTypeExpression, cFormat, "=MOD(ROW(),2)=0")

For row As Integer = 4 To 19
For col As Integer = 1 To 9
Call sheet.WriteNumber(row, col, row + col)

This is an abstract class. You can't create an instance, but you can get one from various plugin functions.

This class has no sub classes.

Some methods using this class:

Blog Entries

Release notes

  • Version 24.2
    • Added XLConditionalFormattingMBS and XLConditionalFormatMBS classes.

The items on this page are in the following plugins: MBS XL Plugin.

XLBookMBS   -   XLConditionalFormattingMBS

The biggest plugin in space...