ExcelScript.ConditionalRangeFill interface can't manage pattern ?

Question

The ConditionalRangeFill interface don't include .setPattern() as a valid fonction : Documentation

In contrary, the RangeFill interface include .setPattern() and even .setPatternColor() as valid fonction : Documentation

By using excel menu, you can set a pattern on a conditional range so this is a feature of excel.

Can you add this to Office script API ?

Answer 1

The ConditionalRangeFill interface in ExcelScript does not include a setPattern() function. However, the RangeFill interface does include setPattern() and setPatternColor() functions. While it is possible to set a pattern on a conditional range using the Excel menu, this feature is not currently available in the Office Script API.

---

References:

• ExcelScript.ConditionalRangeFill interface documentation
• ExcelScript.RangeFill interface documentation
• Set range format using the Excel JavaScript API