{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Intro","David's UDF","Within the window","REMOTE CONTROL","WE","WISH","YOU","A","MERRY","CHRISTMAS","AND","A ","HAPPY","NEW","YEAR!","ShapeLists","Links & Feedback"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":1,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Intro","index":0,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[20,6,20,12]]}
[{"$f":"\"Create Christmas Lights Using Excel Sheets\"&CHAR(10)&\"Video 00171\"","v":"Create Christmas Lights Using Excel Sheets\nVideo 00171"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Original Post from David Hagar!    #Excel Impossibly Easy #2: Change Sheet Tab Color with a User-Defined Worksheet Formula    "]
[null,null,null,"https://dhexcel1.wordpress.com/2017/09/01/excel-impossibly-easy-2-change-sheet-tab-color-with-a-user-defined-worksheet-formula/"]

{"sheet":"David's UDF","index":1,"n_rows":23,"n_cols":34,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Step","Text"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,1,"--Function name--",{"$f":"IF($V2=TRUE,Y2,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,2,"--------------------------------------------Define variables------------------------------------------------",{"$f":"IF($V3=TRUE,Y3,\"\")","v":""},1,{"$f":"IF($V3=TRUE,AA3,\"\")","v":""},2,{"$f":"IF($V3=TRUE,AC3,\"\")","v":""},3,{"$f":"IF($V3=TRUE,AE3,\"\")","v":""},4,{"$f":"IF($V3=TRUE,AG3,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,3,"<--- Change color of which sheet?",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,4,"<---Create sheet tab color using combination of Red/Green/Blue values.",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://dhexcel1.wordpress.com/"]
[]
[]
[]
[]
[]
[null,"=ChangeTabColor(\"Sheet1\",255,0,0)"]

{"sheet":"Within the window","index":2,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"https://youtu.be/u1hqh_3v4Js"]

{"sheet":"REMOTE CONTROL","index":3,"n_rows":35,"n_cols":29,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"INDEX(M13:M35,AB1)","v":"WE"}]
[]
[]
[null,null,{"$f":"RAND()","v":0.23304807007338701}]
[]
["Lights on!",null,"Random"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://www.myspreadsheetlab.com/blog/"]
[null,null,null,null,"Add SheetNames Below",null,"Magical UDF !"]
[null,null,null,null,"WE",null,{"$f":"IF($A$6=\"Lights off!\",ChangeTabColor($E10,255,255,255),\nIF($C$6=\"Random\",CHOOSE(RANDBETWEEN(1,2),ChangeTabColor($E10,255,0,0),ChangeTabColor($E10,0,100,0)),\nIF($C$6=\"Rotating\",CHOOSE(ROUND(1+$C$4,0),ChangeTabColor($E10,255,0,0),ChangeTabColor($E10,0,100,0)))))","v":0}]
[null,null,null,null,"WISH",null,{"$f":"IF($A$6=\"Lights off!\",ChangeTabColor($E11,255,255,255),\nIF($C$6=\"Random\",CHOOSE(RANDBETWEEN(1,2),ChangeTabColor($E11,255,0,0),ChangeTabColor($E11,0,100,0)),\nIF($C$6=\"Rotating\",CHOOSE(ROUND(1+$C$4,0),ChangeTabColor($E11,255,0,0),ChangeTabColor($E11,0,100,0)))))","v":0}]
[null,null,null,null,"YOU",null,{"$f":"IF($A$6=\"Lights off!\",ChangeTabColor($E12,255,255,255),\nIF($C$6=\"Random\",CHOOSE(RANDBETWEEN(1,2),ChangeTabColor($E12,255,0,0),ChangeTabColor($E12,0,100,0)),\nIF($C$6=\"Rotating\",CHOOSE(ROUND(1+$C$4,0),ChangeTabColor($E12,255,0,0),ChangeTabColor($E12,0,100,0)))))","v":0},null,null,null,null,null,"Lyrics"]
[null,null,null,null,"A",null,{"$f":"IF($A$6=\"Lights off!\",ChangeTabColor($E13,255,255,255),\nIF($C$6=\"Random\",CHOOSE(RANDBETWEEN(1,2),ChangeTabColor($E13,255,0,0),ChangeTabColor($E13,0,100,0)),\nIF($C$6=\"Rotating\",CHOOSE(ROUND(1+$C$4,0),ChangeTabColor($E13,255,0,0),ChangeTabColor($E13,0,100,0)))))","v":0},null,null,null,null,null,"WE",1]
[null,null,null,null,"MERRY",null,{"$f":"IF($A$6=\"Lights off!\",ChangeTabColor($E14,255,255,255),\nIF($C$6=\"Random\",CHOOSE(RANDBETWEEN(1,2),ChangeTabColor($E14,255,0,0),ChangeTabColor($E14,0,100,0)),\nIF($C$6=\"Rotating\",CHOOSE(ROUND(1+$C$4,0),ChangeTabColor($E14,255,0,0),ChangeTabColor($E14,0,100,0)))))","v":0},null,null,null,null,null,"WISH",2]
[null,null,null,null,"CHRISTMAS",null,{"$f":"IF($A$6=\"Lights off!\",ChangeTabColor($E15,255,255,255),\nIF($C$6=\"Random\",CHOOSE(RANDBETWEEN(1,2),ChangeTabColor($E15,255,0,0),ChangeTabColor($E15,0,100,0)),\nIF($C$6=\"Rotating\",CHOOSE(ROUND(1+$C$4,0),ChangeTabColor($E15,255,0,0),ChangeTabColor($E15,0,100,0)))))","v":0},null,null,null,null,null,"YOU",3]
[null,null,null,null,"AND",null,{"$f":"IF($A$6=\"Lights off!\",ChangeTabColor($E16,255,255,255),\nIF($C$6=\"Random\",CHOOSE(RANDBETWEEN(1,2),ChangeTabColor($E16,255,0,0),ChangeTabColor($E16,0,100,0)),\nIF($C$6=\"Rotating\",CHOOSE(ROUND(1+$C$4,0),ChangeTabColor($E16,255,0,0),ChangeTabColor($E16,0,100,0)))))","v":0},null,null,null,null,null,"A",4]
[null,null,null,null,"A ",null,{"$f":"IF($A$6=\"Lights off!\",ChangeTabColor($E17,255,255,255),\nIF($C$6=\"Random\",CHOOSE(RANDBETWEEN(1,2),ChangeTabColor($E17,255,0,0),ChangeTabColor($E17,0,100,0)),\nIF($C$6=\"Rotating\",CHOOSE(ROUND(1+$C$4,0),ChangeTabColor($E17,255,0,0),ChangeTabColor($E17,0,100,0)))))","v":0},null,null,null,null,null,"MERRY",5]
[null,null,null,null,"HAPPY",null,{"$f":"IF($A$6=\"Lights off!\",ChangeTabColor($E18,255,255,255),\nIF($C$6=\"Random\",CHOOSE(RANDBETWEEN(1,2),ChangeTabColor($E18,255,0,0),ChangeTabColor($E18,0,100,0)),\nIF($C$6=\"Rotating\",CHOOSE(ROUND(1+$C$4,0),ChangeTabColor($E18,255,0,0),ChangeTabColor($E18,0,100,0)))))","v":0},null,null,null,null,null,"CHRISTMAS",6]
[null,null,null,null,"NEW",null,{"$f":"IF($A$6=\"Lights off!\",ChangeTabColor($E19,255,255,255),\nIF($C$6=\"Random\",CHOOSE(RANDBETWEEN(1,2),ChangeTabColor($E19,255,0,0),ChangeTabColor($E19,0,100,0)),\nIF($C$6=\"Rotating\",CHOOSE(ROUND(1+$C$4,0),ChangeTabColor($E19,255,0,0),ChangeTabColor($E19,0,100,0)))))","v":0},null,null,null,null,null,"WE",7]
[null,null,null,null,"YEAR!",null,{"$f":"IF($A$6=\"Lights off!\",ChangeTabColor($E20,255,255,255),\nIF($C$6=\"Random\",CHOOSE(RANDBETWEEN(1,2),ChangeTabColor($E20,255,0,0),ChangeTabColor($E20,0,100,0)),\nIF($C$6=\"Rotating\",CHOOSE(ROUND(1+$C$4,0),ChangeTabColor($E20,255,0,0),ChangeTabColor($E20,0,100,0)))))","v":0},null,null,null,null,null,"WISH",8]
[null,null,null,null,null,null,null,null,null,null,null,null,"YOU",9]
[null,null,null,null,null,null,null,null,null,null,null,null,"A",10]
[null,null,null,null,null,null,null,null,null,null,null,null,"MERRY",11]
[null,null,null,null,null,null,null,null,null,null,null,null,"CHRISTMAS",12]
[null,null,null,null,null,null,null,null,null,null,null,null,"WE",13]
[null,null,null,null,null,null,null,null,null,null,null,null,"WISH",14]
[null,null,null,null,null,null,null,null,null,null,null,null,"YOU",15]
[null,null,null,null,null,null,null,null,null,null,null,null,"A",16]
[null,null,null,null,null,null,null,null,null,null,null,null,"MERRY",17]
[null,null,null,null,null,null,null,null,null,null,null,null,"CHRISTMAS",18]
[null,null,null,null,null,null,null,null,null,null,null,null,"AND",19]
[null,null,null,null,null,null,null,null,null,null,null,null,"A ",20]
[null,null,null,null,null,null,null,null,null,null,null,null,"HAPPY",21]
[null,null,null,null,null,null,null,null,null,null,null,null,"NEW",22]
[null,null,null,null,null,null,null,null,null,null,null,null,"YEAR!",23]

{"sheet":"WE","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"WISH","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"YOU","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"A","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"MERRY","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"CHRISTMAS","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AND","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"A ","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"HAPPY","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"NEW","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"YEAR!","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ShapeLists","index":15,"n_rows":140,"n_cols":4,"rows_kept":140,"cut":false,"hidden":false,"merged":[]}
["Color Name","Red","Green","Blue"]
["alice blue","240","248","255"]
["antique white","250","235","215"]
["aqua","0","255","255"]
["aqua marine","127","255","212"]
["azure","240","255","255"]
["beige","245","245","220"]
["bisque","255","228","196"]
["black","0","0","0"]
["blanched almond","255","235","205"]
["blue","0","0","255"]
["blue violet","138","43","226"]
["brown","165","42","42"]
["burly wood","222","184","135"]
["cadet blue","951","581","60"]
["chart reuse","127","255","0"]
["chocolate","210","105","30"]
["coral","255","127","80"]
["corn flower blue","100","149","237"]
["corn silk","255","248","220"]
["crimson","220","20","60"]
["cyan","0","255","255"]
["dark blue","0","0","139"]
["dark cyan","0","139","139"]
["dark golden rod","184","134","11"]
["dark gray / dark grey","169","169","169"]
["dark green","0","100","0"]
["dark khaki","189","183","107"]
["dark magenta","139","0","139"]
["dark olive green","85","107","47"]
["dark orange","255","140","0"]
["dark orchid","153","50","204"]
["dark red","139","0","0"]
["dark salmon","233","150","122"]
["dark sea green","143","188","143"]
["dark slate blue","72","61","139"]
["dark slate gray","47","79","79"]
["dark turquoise","0","206","209"]
["dark violet","148","0","211"]
["deep pink","255","20","147"]
["deep sky blue","0","191","255"]
["dim gray / dim grey","105","105","105"]
["dodger blue",30,144,255]
["firebrick","178","34","34"]
["floral white","255","250","240"]
["forest green","34","139","34"]
["gainsboro","220","220","220"]
["ghost white","248","248","255"]
["gold","255","215","0"]
["golden rod","218","165","32"]
["gray / grey","128","128","128"]
["green","0","128","0"]
["green yellow","173","255","47"]
["honeydew","240","255","240"]
["hot pink","255","105","180"]
["indian red","205","92","92"]
["indigo","75","0","130"]
["ivory","255","255","240"]
["khaki","240","230","140"]
["lavender","230","230","250"]
["lavender blush","255","240","245"]
["lawn green","124","252","0"]
["lemon chiffon","255","250","205"]
["light blue","173","216","230"]
["light coral","240","128","128"]
["light cyan","224","255","255"]
["light golden rod yellow","250","250","210"]
["light gray / light grey","211","211","211"]
["light green","144","238","144"]
["light pink","255","182","193"]
["light salmon","255","160","122"]
["light sea green",32,178,170]
["light sky blue","135","206","250"]
["light slate gray","119","136","153"]
["light steel blue","176","196","222"]
["light yellow","255","255","224"]
["lime","0","255","0"]
["lime green","50","205","50"]
["linen","250","240","230"]
["magenta/fuchsia","255","0","255"]
["maroon","128","0","0"]
["medium aqua marine","102","205","170"]
["medium blue","0","0","205"]
["medium orchid","186","85","211"]
["medium purple","147","112","219"]
["medium sea green",60,179,113]
["medium slate blue","123","104","238"]
["medium spring green","0","250","154"]
["medium turquoise",72,209,204]
["medium violet red","199","21","133"]
["midnight blue","25","25","112"]
["mint cream","245","255","250"]
["misty rose","255","228","225"]
["moccasin","255","228","181"]
["navajo white","255","222","173"]
["navy","0","0","128"]
["old lace","253","245","230"]
["olive","128","128","0"]
["olive drab","107","142","35"]
["orange","255","165","0"]
["orange red","255","69","0"]
["orchid","218","112","214"]
["pale golden rod","238","232","170"]
["pale green","152","251","152"]
["pale turquoise","175","238","238"]
["pale violet red","219","112","147"]
["papaya whip","255","239","213"]
["peach puff","255","218","185"]
["peru","205","133","63"]
["pink","255","192","203"]
["plum","221","160","221"]
["powder blue","176","224","230"]
["purple","128","0","128"]
["red","255","0","0"]
["rosy brown","188","143","143"]
["royal blue",65,"105","225"]
["saddle brown","139","69","19"]
["salmon","250","128","114"]
["sandy brown","244","164","96"]
["sea green","46","139","87"]
["sea shell","255","245","238"]
["sienna","160","82","45"]
["silver","192","192","192"]
["sky blue","135","206","235"]
["slate blue","106","90","205"]
["slate gray","112","128","144"]
["snow","255","250","250"]
["spring green","0","255","127"]
["steel blue","701","301","80"]
["tan","210","180","140"]
["teal","0","128","128"]
["thistle","216","191","216"]
["tomato","255","99","71"]
["turquoise",64,224,208]
["violet","238","130","238"]
["wheat","245","222","179"]
["white","255","255","255"]
["white smoke","245","245","245"]
["yellow","255","255","0"]
["yellow green","154","205","50"]

{"sheet":"Links & Feedback","index":16,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[24,6,24,12],[25,6,25,12],[26,6,26,12],[27,6,27,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"My video!","https://youtu.be/NsCT3Rj7X5g"]
[null,null,null,null,null,"David Hager's UDF post!","https://dhexcel1.wordpress.com/2017/09/01/excel-impossibly-easy-2-change-sheet-tab-color-with-a-user-defined-worksheet-formula/"]
[null,null,null,null,null,"What is a UDF? Vertex42","https://www.vertex42.com/blog/excel-formulas/custom-user-defined-functions.html"]
[null,null,null,null,null,"Read my post!","http://www.myspreadsheetlab.com/video-00171-create-christmas-lights-using-excel-sheets/"]
[null,null,null,null,null,"My Excel files:","Click here to see my Excel files"]
[null,null,null,null,null,"Join Mr Excel's FREE help forum!","http://www.mrexcel.com/forum/forum.php"]
[null,null,null,null,null,"One of my favorite Excel books!","'Control Shift Enter' by Mike Girvin!"]