Applying direct formatting to spilled arrays in Excel could cause issues if the data changes shape or size. Formula-based ...

As a result of using a named range rather than direct cell references, I can guarantee that I've not accidentally selected the wrong cells. What's more, because the referenced ran ...