1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
function changeBackgroundColor(){
var sheet = SpreadsheetApp.getActive().getSheetByName('圖鑑');

var mainBg = "AA9" //"#aadee2"
var tabBg = "AA10" //#72d9e1"
var boxTableBg = "AA11" //"white"
var boxInnerBorder = "AA12"
var boxOuterBorder = "AA13"
var bestTableBg = "AA14"
var bestInnerBorder = "AA15"
var bestOuterBorder = "AA16"
var mainTableBg = "AA17" //"white"
var mainInnerBorder = "AA18"
var mainOuterBorder = "AA19"

//背景
var bgRange1 = "A1:AT501";
var range1 = sheet.getRange(bgRange1);
var input1 = sheet.getRange(mainBg);
var color1 = input1.getValue();
range1.setBackground(color1);

//汪
var bgRange4 = "J3:J6";
var range4 = sheet.getRange(bgRange4);
range4.setBackground("white");

//攜帶寶可夢
var bgRange2 = "C3:H6";
var range2 = sheet.getRange(bgRange2);
var input2 = sheet.getRange(bestTableBg);
var color2 = input2.getValue();
range2.setBackground(color2);

//攜帶寶可夢 - 內框
var inputBestInnerBorder = sheet.getRange(bestInnerBorder);
var colorBestInnerBorder = inputBestInnerBorder.getValue();
range2.setBorder(null,null,null,null,true,true,colorBestInnerBorder, SpreadsheetApp.BorderStyle.DOTTED);

//攜帶寶可夢 - 外框
var inputBestOuterBorder = sheet.getRange(bestOuterBorder);
var colorBestOuterBorder = inputBestOuterBorder.getValue();
range2.setBorder(true,true,true,true,null,null,colorBestOuterBorder, SpreadsheetApp.BorderStyle.DOUBLE);

//寶可夢盒子
var bgRange3 = "C9:H500";
var range3 = sheet.getRange(bgRange3);
var inputBox = sheet.getRange(boxTableBg);
var colorBox = inputBox.getValue();
range3.setBackground(colorBox);

//寶可夢盒子 - 內框
var inputBoxInnerBorder = sheet.getRange(boxInnerBorder);
var colorBoxInnerBorder = inputBoxInnerBorder.getValue();
range3.setBorder(null,null,null,null,true,true,colorBoxInnerBorder, SpreadsheetApp.BorderStyle.DOTTED);

//寶可夢盒子 - 外框
var inputBoxOuterBorder = sheet.getRange(boxOuterBorder);
var colorBoxOuterBorder = inputBoxOuterBorder.getValue();
range3.setBorder(true,true,true,true,null,null,colorBoxOuterBorder, SpreadsheetApp.BorderStyle.DOUBLE);

//紀錄
var bgRange5 = "J9:W500";
var range5 = sheet.getRange(bgRange5);
var input5 = sheet.getRange(mainTableBg);
var color5 = input5.getValue();
range5.setBackground(color5);

//紀錄 - 內框
var inputMainInnerBorder = sheet.getRange(mainInnerBorder);
var colorMainInnerBorder = inputMainInnerBorder.getValue();
range5.setBorder(null,null,null,null,true,true,colorMainInnerBorder, SpreadsheetApp.BorderStyle.DOTTED);

//紀錄 - 外框
var inputMainOuterBorder = sheet.getRange(mainOuterBorder);
var colorMainOuterBorder = inputMainOuterBorder.getValue();
range5.setBorder(true,true,true,true,null,null,colorMainOuterBorder, SpreadsheetApp.BorderStyle.DOUBLE);

//標頭
var rangeList = sheet.getRangeList(['C2', 'C8','J8:W8']);
var inputTab = sheet.getRange(tabBg);
var colorTab = inputTab.getValue();
rangeList.setBackground(colorTab);
rangeList.setBorder(true,true,true,true,null,null,colorMainOuterBorder, SpreadsheetApp.BorderStyle.DOUBLE);


//變色表格
var rangeColorBox = sheet.getRange("Y9:AB19");
rangeColorBox.setBackground("white");
}