Conditional formatting of a dynamic array

Conditional formatting of a dynamic array

Posted by: Jean.s on 29 December 2025, 5:56 am EST

• 

  Jean.s

  • Post Options:
  • Link
    Copy

  Posted 29 December 2025, 5:56 am EST

  “Hi,
  
  how can I apply a conditional formatting rule to the result of a dynamic array (specifically, to the entire region of the spilled array)?”

  Best regards

• 

  chirag.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 29 December 2025, 9:05 am EST

  Hi,

  In SpreadJS (following the OpenXML standard), there is currently no direct way to apply conditional formatting specifically to a spill range.

  Conditional formatting rules must be defined over static ranges, while dynamic array spill ranges are resolved only at calculation time. Because of this design, the formatting cannot be bound dynamically to the spill range itself.

  Recommended approach: The usual workaround is to apply the conditional formatting rule to a sufficiently large fixed range (such as a column or a predefined row range) and use a relative formula. The rule will then affect only the cells populated by the dynamic array output.

  This is a known Excel behavior and not specific to SpreadJS. For additional background and examples, you may find this discussion helpful:
  
  https://stackoverflow.com/questions/54856036/how-to-dynamically-format-an-excel-spill-range

  Please let us know if you require any further clarification.

  Kind Regards,
  
  Chirag