Drag table rows over existing colored rows

[yitzymerm]

I have a sheet that I made all cells one color (to serve as a background) besides the table data that has different format and colors.

My question is, how do I make when I drag down the bottom row in the table to add a new row that the table format and color should override the existing colored cells?

Book2
	A	B	C	D	E	F	G	H	I	J
1
2
3
4				Name	Column1	Color	Team
5				Martin		Red	5
6				Jack		Blue	4
7				Lucy		Green	9
8				Mario		Grey	3
9				Jill		Black	6
10
11
12
13
14
15
Sheet1

 

[Herakles]

Create a jpeg file with just one colour, the colour that you want the background to be. I created one, size as in this image below.

Set it up a as the backgound in Page Layout. It is used as the background to the entire worksheet.

Everything just sits on top of this background. I've never done this before. I wonder if the size of the jpeg matters.

 

[yitzymerm]

It could work as a solution but only partially, cause #1 an image when put as background of entire sheet becomes like tiles, and also the color is not 100% accurate from an image, the one i'm looking to put. But main thing is that I'm also looking to put in a specific area and not over the entire sheet.

Thanks.