Dynamic Arrays, Spill range format
When a Spill range changes (eg due to the source data changing) it would be nice if any Formatting that is applied to the Spill Formula Cell is also applied to the entire Spill Range.
Roger Govier commented
Great idea and much needed. Look forward to seeing this released.
Wyn Hopkins commented
This would be fantastic
Kenneth Barber commented
But if the array shrinks, should the formatting remain on the cells that the array previous occupied?
Everyone wants this functionality, I especially.