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.
Example
// 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)
Next
Next

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...