To maintain the color formatting, highlight the bottom two rows of the template, click on the small box in the bottom right corner of the last cell and drag this down as far as desired.

Good Luck

Bruce