Applying direct formatting to spilled arrays in Excel could cause issues if the ... formatting adjustments when the data parameters change. Placing a dollar symbol before the column reference ...