Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old


Sets the foreground color of the fill pattern.

Component Version macOS Windows Linux Server iOS SDK
XL 14.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.ConditionalFormat.SetPatternForegroundColor"; bookRef; ConditionalFormatRef; Value )   More


Parameter Description Example
bookRef The reference to the workbook. Please use XL.LoadBook to load a file. $ref
ConditionalFormatRef The reference number for the conditional format. $ConditionalFormat
Value The new color value. 10


Returns OK or error.


Sets the foreground color of the fill pattern.

See also

Created 30th March 2024, last changed 30th March 2024

XL.ConditionalFormat.SetPatternBackgroundColor - XL.ConditionalFormating.Add2ColorScaleFormulaRule