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


Sets the fill pattern.

Component Version macOS Windows Linux Server iOS SDK
XL 14.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.ConditionalFormat.SetFillPattern"; 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 pattern. 3


Returns OK or error.


Sets the fill pattern.

50% Gray2
75% Gray3
25% Gray4
Horizontal Stripes5
Vertical Stripes6
Reverse Diagonal Stripes7
Diagonal Stripes8
Diagonal Cross Hatch9
Thick Diagonal Stripe9
Thin Horizontal Stripe11
Thin Vertical Stripe12
Thin Reverse Diagonal Stripe13
Thin Diagonal Stripe14
Thin Horizontal Cross Hatch15
Thin Diagonal Cross Hatch16
Gray 12P517
Gray 6P2518

see table of fill patterns here:

See also

Example Databases

Blog Entries

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

XL.ConditionalFormat.SetCustomNumFormat - XL.ConditionalFormat.SetNumFormat