{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Dataset","Overview","Cell Styles","Font Color","Format Cells","Alternative Rows","Fing and Replace","Conditional Formatting-Text","Conditional Formatting-Numb ","Format Painter","Change Color","Active Row & Column"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Dataset","index":0,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Sample Dataset"]
[]
[null,"Order Date","Region","Rep","Item","Units","Unit Cost","Total Sales"]
[null,"2023-01-06","East","Jones","Pencil",53,1.5,{"$f":"F5*G5","v":79.5}]
[null,"2023-01-23","Central","Kyell","Notebook",89,2.5499999999999998,{"$f":"F6*G6","v":226.95}]
[null,"2023-02-09","Central","Jardine","Pencil",56,1.02,57.120000000000005]
[null,"2023-02-26","Central","Gill","Pen",62,1.82,112.84]
[null,"2023-03-15","West","Sorvino","Pencil",57,1.06,60.42]
[null,"2023-04-01","East","Jones","Notebook",59,3,177]
[null,"2023-04-18","Central","Andrews","Pencil",83,1.69,140.26999999999998]
[null,"2022-05-05","Central","Jardine","Pencil Case",99,3.54,350.46]
[null,"2022-05-22","West","Thompson","Pencil",83,0.98,81.34]
[null,"2022-06-08","East","Jones","Notebook",71,4.07,288.97000000000003]
[null,"2022-06-25","Central","Morgan","Pencil",60,1.08,64.800000000000011]
[null,"2022-07-12","East","Howard","Pencil Case",53,2,106]
[null,"2022-07-29","East","Parent","Stapler",73,3.22,235.06]
[null,"2022-08-15","East","Jones","Pencil",91,0.8,72.8]
[null,"2022-09-01","Central","Smith","Compass",70,2.41,168.70000000000002]
[null,"2022-09-18","East","Jones","Eraser",96,0.6,57.599999999999994]
[null,"2022-10-05","Central","Morgan","Stapler",100,3.5,350]
[null,"2022-10-22","East","Jones","Pen",68,2.0499999999999998,139.39999999999998]

{"sheet":"Overview","index":1,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Highlighting Cells/Text/Row/Column"]
[]
[null,"Order Date","Region","Rep","Item","Units","Unit Cost","Total Sales"]
[null,"2023-01-06","East","Jones","Pencil",53,1.5,79.5]
[null,"2023-01-23","Central","Kyell","Notebook",89,2.5499999999999998,226.95]
[null,"2023-02-09","Central","Jardine","Pencil",56,1.02,57.120000000000005]
[null,"2023-02-26","Central","Gill","Pen",62,1.82,112.84]
[null,"2023-03-15","West","Sorvino","Pencil",57,1.06,60.42]
[null,"2023-04-01","East","Jones","Notebook",59,3,177]
[null,"2023-04-18","Central","Andrews","Pencil",83,1.69,140.26999999999998]
[null,"2022-05-05","Central","Jardine","Pencil Case",99,3.54,350.46]
[null,"2022-05-22","West","Thompson","Pencil",83,0.98,81.34]
[null,"2022-06-08","East","Jones","Notebook",71,4.07,288.97000000000003]
[null,"2022-06-25","Central","Morgan","Pencil",60,1.08,64.800000000000011]
[null,"2022-07-12","East","Howard","Pencil Case",53,2,106]
[null,"2022-07-29","East","Parent","Stapler",73,3.22,235.06]
[null,"2022-08-15","East","Jones","Pencil",91,0.8,72.8]
[null,"2022-09-01","Central","Smith","Compass",70,2.41,168.70000000000002]
[null,"2022-09-18","East","Jones","Eraser",96,0.6,57.599999999999994]
[null,"2022-10-05","Central","Morgan","Stapler",100,3.5,350]
[null,"2022-10-22","East","Jones","Pen",68,2.0499999999999998,139.39999999999998]

{"sheet":"Cell Styles","index":2,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Using Cell Styles to Highlight Cells"]
[]
[null,"Order Date","Region","Rep","Item","Units","Unit Cost","Total Sales"]
[null,"2023-01-06","East","Jones","Pencil",53,1.5,{"$f":"F5*G5","v":79.5}]
[null,"2023-01-23","Central","Kyell","Notebook",89,2.5499999999999998,{"$f":"F6*G6","v":226.95}]
[null,"2023-02-09","Central","Jardine","Pencil",56,1.02,57.120000000000005]
[null,"2023-02-26","Central","Gill","Pen",62,1.82,112.84]
[null,"2023-03-15","West","Sorvino","Pencil",57,1.06,60.42]
[null,"2023-04-01","East","Jones","Notebook",59,3,177]
[null,"2023-04-18","Central","Andrews","Pencil",83,1.69,140.26999999999998]
[null,"2022-05-05","Central","Jardine","Pencil Case",99,3.54,350.46]
[null,"2022-05-22","West","Thompson","Pencil",83,0.98,81.34]
[null,"2022-06-08","East","Jones","Notebook",71,4.07,288.97000000000003]
[null,"2022-06-25","Central","Morgan","Pencil",60,1.08,64.800000000000011]
[null,"2022-07-12","East","Howard","Pencil Case",53,2,106]
[null,"2022-07-29","East","Parent","Stapler",73,3.22,235.06]
[null,"2022-08-15","East","Jones","Pencil",91,0.8,72.8]
[null,"2022-09-01","Central","Smith","Compass",70,2.41,168.70000000000002]
[null,"2022-09-18","East","Jones","Eraser",96,0.6,57.599999999999994]
[null,"2022-10-05","Central","Morgan","Stapler",100,3.5,350]
[null,"2022-10-22","East","Jones","Pen",68,2.0499999999999998,139.39999999999998]

{"sheet":"Font Color","index":3,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Use of Font Color for Highlighting Text Within a Cell"]
[]
[null,"Order Date","Region","Rep","Item","Units","Unit Cost","Total Sales"]
[null,"2023-01-06","East","Jones","Pencil",53,1.5,{"$f":"F5*G5","v":79.5}]
[null,"2023-01-23","Central","Kyell","Notebook",89,2.5499999999999998,{"$f":"F6*G6","v":226.95}]
[null,"2023-02-09","Central","Jardine","Pencil",56,1.02,57.120000000000005]
[null,"2023-02-26","Central","Gill","Pen",62,1.82,112.84]
[null,"2023-03-15","West","Sorvino","Pencil",57,1.06,60.42]
[null,"2023-04-01","East","Jones","Notebook",59,3,177]
[null,"2023-04-18","Central","Andrews","Pencil",83,1.69,140.26999999999998]
[null,"2022-05-05","Central","Jardine","Pencil Case",99,3.54,350.46]
[null,"2022-05-22","West","Thompson","Pencil",83,0.98,81.34]
[null,"2022-06-08","East","Jones","Notebook",71,4.07,288.97000000000003]
[null,"2022-06-25","Central","Morgan","Pencil",60,1.08,64.800000000000011]
[null,"2022-07-12","East","Howard","Pencil Case",53,2,106]
[null,"2022-07-29","East","Parent","Stapler",73,3.22,235.06]
[null,"2022-08-15","East","Jones","Pencil",91,0.8,72.8]
[null,"2022-09-01","Central","Smith","Compass",70,2.41,168.70000000000002]
[null,"2022-09-18","East","Jones","Eraser",96,0.6,57.599999999999994]
[null,"2022-10-05","Central","Morgan","Stapler",100,3.5,350]
[null,"2022-10-22","East","Jones","Pen",68,2.0499999999999998,139.39999999999998]

{"sheet":"Format Cells","index":4,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Applying Format Cells to Highlight Entire Row"]
[]
[null,"Order Date","Region","Rep","Item","Units","Unit Cost","Total Sales"]
[null,"2023-01-06","East","Jones","Pencil",53,1.5,{"$f":"F5*G5","v":79.5}]
[null,"2023-01-23","Central","Kyell","Notebook",89,2.5499999999999998,{"$f":"F6*G6","v":226.95}]
[null,"2023-02-09","Central","Jardine","Pencil",56,1.02,57.120000000000005]
[null,"2023-02-26","Central","Gill","Pen",62,1.82,112.84]
[null,"2023-03-15","West","Sorvino","Pencil",57,1.06,60.42]
[null,"2023-04-01","East","Jones","Notebook",59,3,177]
[null,"2023-04-18","Central","Andrews","Pencil",83,1.69,140.26999999999998]
[null,"2022-05-05","Central","Jardine","Pencil Case",99,3.54,350.46]
[null,"2022-05-22","West","Thompson","Pencil",83,0.98,81.34]
[null,"2022-06-08","East","Jones","Notebook",71,4.07,288.97000000000003]
[null,"2022-06-25","Central","Morgan","Pencil",60,1.08,64.800000000000011]
[null,"2022-07-12","East","Howard","Pencil Case",53,2,106]
[null,"2022-07-29","East","Parent","Stapler",73,3.22,235.06]
[null,"2022-08-15","East","Jones","Pencil",91,0.8,72.8]
[null,"2022-09-01","Central","Smith","Compass",70,2.41,168.70000000000002]
[null,"2022-09-18","East","Jones","Eraser",96,0.6,57.599999999999994]
[null,"2022-10-05","Central","Morgan","Stapler",100,3.5,350]
[null,"2022-10-22","East","Jones","Pen",68,2.0499999999999998,139.39999999999998]

{"sheet":"Alternative Rows","index":5,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Highlighting Alternative Rows with VBA Code"]
[]
[null,"Order Date","Region","Rep","Item","Units","Unit Cost","Total Sales"]
[null,"2023-01-06","East","Jones","Pencil",53,1.5,{"$f":"F5*G5","v":79.5}]
[null,"2023-01-23","Central","Kyell","Notebook",89,2.5499999999999998,{"$f":"F6*G6","v":226.95}]
[null,"2023-02-09","Central","Jardine","Pencil",56,1.02,57.120000000000005]
[null,"2023-02-26","Central","Gill","Pen",62,1.82,112.84]
[null,"2023-03-15","West","Sorvino","Pencil",57,1.06,60.42]
[null,"2023-04-01","East","Jones","Notebook",59,3,177]
[null,"2023-04-18","Central","Andrews","Pencil",83,1.69,140.26999999999998]
[null,"2022-05-05","Central","Jardine","Pencil Case",99,3.54,350.46]
[null,"2022-05-22","West","Thompson","Pencil",83,0.98,81.34]
[null,"2022-06-08","East","Jones","Notebook",71,4.07,288.97000000000003]
[null,"2022-06-25","Central","Morgan","Pencil",60,1.08,64.800000000000011]
[null,"2022-07-12","East","Howard","Pencil Case",53,2,106]
[null,"2022-07-29","East","Parent","Stapler",73,3.22,235.06]
[null,"2022-08-15","East","Jones","Pencil",91,0.8,72.8]
[null,"2022-09-01","Central","Smith","Compass",70,2.41,168.70000000000002]
[null,"2022-09-18","East","Jones","Eraser",96,0.6,57.599999999999994]
[null,"2022-10-05","Central","Morgan","Stapler",100,3.5,350]
[null,"2022-10-22","East","Jones","Pen",68,2.0499999999999998,139.39999999999998]

{"sheet":"Fing and Replace","index":6,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Using Fing and Replace Feature for Highlighting Cells"]
[]
[null,"Order Date","Region","Rep","Item","Units","Unit Cost","Total Sales"]
[null,"2023-01-06","East","Jones","Pencil",53,1.5,{"$f":"F5*G5","v":79.5}]
[null,"2023-01-23","Central","Kyell","Notebook",89,2.5499999999999998,{"$f":"F6*G6","v":226.95}]
[null,"2023-02-09","Central","Jardine","Pencil",56,1.02,57.120000000000005]
[null,"2023-02-26","Central","Gill","Pen",62,1.82,112.84]
[null,"2023-03-15","West","Sorvino","Pencil",57,1.06,60.42]
[null,"2023-04-01","East","Jones","Notebook",59,3,177]
[null,"2023-04-18","Central","Andrews","Pencil",83,1.69,140.26999999999998]
[null,"2022-05-05","Central","Jardine","Pencil Case",99,3.54,350.46]
[null,"2022-05-22","West","Thompson","Pencil",83,0.98,81.34]
[null,"2022-06-08","East","Jones","Notebook",71,4.07,288.97000000000003]
[null,"2022-06-25","Central","Morgan","Pencil",60,1.08,64.800000000000011]
[null,"2022-07-12","East","Howard","Pencil Case",53,2,106]
[null,"2022-07-29","East","Parent","Stapler",73,3.22,235.06]
[null,"2022-08-15","East","Jones","Pencil",91,0.8,72.8]
[null,"2022-09-01","Central","Smith","Compass",70,2.41,168.70000000000002]
[null,"2022-09-18","East","Jones","Eraser",96,0.6,57.599999999999994]
[null,"2022-10-05","Central","Morgan","Stapler",100,3.5,350]
[null,"2022-10-22","East","Jones","Pen",68,2.0499999999999998,139.39999999999998]

{"sheet":"Conditional Formatting-Text","index":7,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Use of Conditional Formatting to Highlight Cells Based on Criteria"]
[]
[null,"Order Date","Region","Rep","Item","Units","Unit Cost","Total Sales"]
[null,"2023-01-06","East","Jones","Pencil",53,1.5,{"$f":"F5*G5","v":79.5}]
[null,"2023-01-23","Central","Kyell","Notebook",89,2.5499999999999998,{"$f":"F6*G6","v":226.95}]
[null,"2023-02-09","Central","Jardine","Pencil",56,1.02,57.120000000000005]
[null,"2023-02-26","Central","Gill","Pen",62,1.82,112.84]
[null,"2023-03-15","West","Sorvino","Pencil",57,1.06,60.42]
[null,"2023-04-01","East","Jones","Notebook",59,3,177]
[null,"2023-04-18","Central","Andrews","Pencil",83,1.69,140.26999999999998]
[null,"2022-05-05","Central","Jardine","Pencil Case",99,3.54,350.46]
[null,"2022-05-22","West","Thompson","Pencil",83,0.98,81.34]
[null,"2022-06-08","East","Jones","Notebook",71,4.07,288.97000000000003]
[null,"2022-06-25","Central","Morgan","Pencil",60,1.08,64.800000000000011]
[null,"2022-07-12","East","Howard","Pencil Case",53,2,106]
[null,"2022-07-29","East","Parent","Stapler",73,3.22,235.06]
[null,"2022-08-15","East","Jones","Pencil",91,0.8,72.8]
[null,"2022-09-01","Central","Smith","Compass",70,2.41,168.70000000000002]
[null,"2022-09-18","East","Jones","Eraser",96,0.6,57.599999999999994]
[null,"2022-10-05","Central","Morgan","Stapler",100,3.5,350]
[null,"2022-10-22","East","Jones","Pen",68,2.0499999999999998,139.39999999999998]

{"sheet":"Conditional Formatting-Numb ","index":8,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Use of Conditional Formatting to Highlight Cells Based on Criteria"]
[]
[null,"Order Date","Region","Rep","Item","Units","Unit Cost","Total Sales"]
[null,"2023-01-06","East","Jones","Pencil",53,1.5,{"$f":"F5*G5","v":79.5}]
[null,"2023-01-23","Central","Kyell","Notebook",89,2.5499999999999998,{"$f":"F6*G6","v":226.95}]
[null,"2023-02-09","Central","Jardine","Pencil",56,1.02,57.120000000000005]
[null,"2023-02-26","Central","Gill","Pen",62,1.82,112.84]
[null,"2023-03-15","West","Sorvino","Pencil",57,1.06,60.42]
[null,"2023-04-01","East","Jones","Notebook",59,3,177]
[null,"2023-04-18","Central","Andrews","Pencil",83,1.69,140.26999999999998]
[null,"2022-05-05","Central","Jardine","Pencil Case",99,3.54,350.46]
[null,"2022-05-22","West","Thompson","Pencil",83,0.98,81.34]
[null,"2022-06-08","East","Jones","Notebook",71,4.07,288.97000000000003]
[null,"2022-06-25","Central","Morgan","Pencil",60,1.08,64.800000000000011]
[null,"2022-07-12","East","Howard","Pencil Case",53,2,106]
[null,"2022-07-29","East","Parent","Stapler",73,3.22,235.06]
[null,"2022-08-15","East","Jones","Pencil",91,0.8,72.8]
[null,"2022-09-01","Central","Smith","Compass",70,2.41,168.70000000000002]
[null,"2022-09-18","East","Jones","Eraser",96,0.6,57.599999999999994]
[null,"2022-10-05","Central","Morgan","Stapler",100,3.5,350]
[null,"2022-10-22","East","Jones","Pen",68,2.0499999999999998,139.39999999999998]

{"sheet":"Format Painter","index":9,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Using Format Painter to Highlight Other Cells"]
[]
[null,"Order Date","Region","Rep","Item","Units","Unit Cost","Total Sales"]
[null,"2023-01-06","East","Jones","Pencil",53,1.5,{"$f":"F5*G5","v":79.5}]
[null,"2023-01-23","Central","Kyell","Notebook",89,2.5499999999999998,{"$f":"F6*G6","v":226.95}]
[null,"2023-02-09","Central","Jardine","Pencil",56,1.02,57.120000000000005]
[null,"2023-02-26","Central","Gill","Pen",62,1.82,112.84]
[null,"2023-03-15","West","Sorvino","Pencil",57,1.06,60.42]
[null,"2023-04-01","East","Jones","Notebook",59,3,177]
[null,"2023-04-18","Central","Andrews","Pencil",83,1.69,140.26999999999998]
[null,"2022-05-05","Central","Jardine","Pencil Case",99,3.54,350.46]
[null,"2022-05-22","West","Thompson","Pencil",83,0.98,81.34]
[null,"2022-06-08","East","Jones","Notebook",71,4.07,288.97000000000003]
[null,"2022-06-25","Central","Morgan","Pencil",60,1.08,64.800000000000011]
[null,"2022-07-12","East","Howard","Pencil Case",53,2,106]
[null,"2022-07-29","East","Parent","Stapler",73,3.22,235.06]
[null,"2022-08-15","East","Jones","Pencil",91,0.8,72.8]
[null,"2022-09-01","Central","Smith","Compass",70,2.41,168.70000000000002]
[null,"2022-09-18","East","Jones","Eraser",96,0.6,57.599999999999994]
[null,"2022-10-05","Central","Morgan","Stapler",100,3.5,350]
[null,"2022-10-22","East","Jones","Pen",68,2.0499999999999998,139.39999999999998]

{"sheet":"Change Color","index":10,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Changing the Format Color of Highlighted Text"]
[]
[null,"Order Date","Region","Rep","Item","Units","Unit Cost","Total Sales"]
[null,"2023-01-06","East","Jones","Pencil",53,1.5,{"$f":"F5*G5","v":79.5}]
[null,"2023-01-23","Central","Kyell","Notebook",89,2.5499999999999998,{"$f":"F6*G6","v":226.95}]
[null,"2023-02-09","Central","Jardine","Pencil",56,1.02,57.120000000000005]
[null,"2023-02-26","Central","Gill","Pen",62,1.82,112.84]
[null,"2023-03-15","West","Sorvino","Pencil",57,1.06,60.42]
[null,"2023-04-01","East","Jones","Notebook",59,3,177]
[null,"2023-04-18","Central","Andrews","Pencil",83,1.69,140.26999999999998]
[null,"2022-05-05","Central","Jardine","Pencil Case",99,3.54,350.46]
[null,"2022-05-22","West","Thompson","Pencil",83,0.98,81.34]
[null,"2022-06-08","East","Jones","Notebook",71,4.07,288.97000000000003]
[null,"2022-06-25","Central","Morgan","Pencil",60,1.08,64.800000000000011]
[null,"2022-07-12","East","Howard","Pencil Case",53,2,106]
[null,"2022-07-29","East","Parent","Stapler",73,3.22,235.06]
[null,"2022-08-15","East","Jones","Pencil",91,0.8,72.8]
[null,"2022-09-01","Central","Smith","Compass",70,2.41,168.70000000000002]
[null,"2022-09-18","East","Jones","Eraser",96,0.6,57.599999999999994]
[null,"2022-10-05","Central","Morgan","Stapler",100,3.5,350]
[null,"2022-10-22","East","Jones","Pen",68,2.0499999999999998,139.39999999999998]

{"sheet":"Active Row & Column","index":11,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Highlighting Active Row and Column"]
[]
[null,"Order Date","Region","Rep","Item","Units","Unit Cost","Total Sales"]
[null,"2023-01-06","East","Jones","Pencil",53,1.5,{"$f":"F5*G5","v":79.5}]
[null,"2023-01-23","Central","Kyell","Notebook",89,2.5499999999999998,{"$f":"F6*G6","v":226.95}]
[null,"2023-02-09","Central","Jardine","Pencil",56,1.02,57.120000000000005]
[null,"2023-02-26","Central","Gill","Pen",62,1.82,112.84]
[null,"2023-03-15","West","Sorvino","Pencil",57,1.06,60.42]
[null,"2023-04-01","East","Jones","Notebook",59,3,177]
[null,"2023-04-18","Central","Andrews","Pencil",83,1.69,140.26999999999998]
[null,"2022-05-05","Central","Jardine","Pencil Case",99,3.54,350.46]
[null,"2022-05-22","West","Thompson","Pencil",83,0.98,81.34]
[null,"2022-06-08","East","Jones","Notebook",71,4.07,288.97000000000003]
[null,"2022-06-25","Central","Morgan","Pencil",60,1.08,64.800000000000011]
[null,"2022-07-12","East","Howard","Pencil Case",53,2,106]
[null,"2022-07-29","East","Parent","Stapler",73,3.22,235.06]
[null,"2022-08-15","East","Jones","Pencil",91,0.8,72.8]
[null,"2022-09-01","Central","Smith","Compass",70,2.41,168.70000000000002]
[null,"2022-09-18","East","Jones","Eraser",96,0.6,57.599999999999994]
[null,"2022-10-05","Central","Morgan","Stapler",100,3.5,350]
[null,"2022-10-22","East","Jones","Pen",68,2.0499999999999998,139.39999999999998]