{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Overview","i. Conditional Formatting","ii. Conditional Formatting","Find & Replace","VBA Code"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Overview","index":0,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[19,3,19,4],[20,3,20,4],[23,1,23,4],[17,1,18,1],[21,1,21,4],[17,3,17,4],[17,2,18,2],[18,3,18,4],[1,1,1,4],[4,1,6,1],[7,1,9,1],[10,1,12,1],[16,3,16,4],[16,1,16,2]]}
[]
[null,"Excel Formula to Change Cell Color Based on Text"]
[]
[null,"Location","Inventory Item","Status","Demand"]
[null,"New York","Clothing","Stocked","More"]
[null,null,"Shoes","Need Supply","Average"]
[null,null,"Jewelry","Need Supply","Less"]
[null,"Los Angeles","Clothing","Stocked","Less"]
[null,null,"Shoes","Need Supply","More"]
[null,null,"Jewelry","Need Supply","Average"]
[null,"Chicago","Clothing","Need Supply","More"]
[null,null,"Shoes","Stocked","Less"]
[null,null,"Jewelry","Stocked","Average"]
[]
[]
[]
[null,"Methods",null,"Process"]
[null,1,"Conditional Formatting","Using Default Cell Rules"]
[null,null,null,"Creating New Rules using Formula"]
[null,2,"Find and Repalce Tool","Direct Fill"]
[null,3,"VBA Code","Coding"]

{"sheet":"i. Conditional Formatting","index":1,"n_rows":13,"n_cols":19,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,6,1],[7,1,9,1],[10,1,12,1],[1,12,1,15],[4,12,6,12],[7,12,9,12],[10,12,12,12]]}
[]
[null,"Excel Formula to Change Cell Color Based on Text",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Location","Inventory Item","Status","Demand",null,null,null,null,null,null,null,"Location","Inventory Item","Status","Demand"]
[null,"New York","Clothing","Stocked","More",null,null,null,null,null,null,null,"Florida","Groceries","Stocked","Less",null,null,"More"]
[null,null,"Shoes","Need Supply","Average",null,null,null,null,null,null,null,null,"Electronic Products","Need Supply","More",null,null,"Average"]
[null,null,"Jewelry","Need Supply","Less",null,null,null,null,null,null,null,null,"Apparel","Need Supply","Average",null,null,"Less"]
[null,"Los Angeles","Clothing","Stocked","Less",null,null,null,null,null,null,null,"New Mexico","Groceries","Stocked","More"]
[null,null,"Shoes","Need Supply","More",null,null,null,null,null,null,null,null,"Electronic Products","Need Supply","Less"]
[null,null,"Jewelry","Need Supply","Average",null,null,null,null,null,null,null,null,"Apparel","Need Supply","Average"]
[null,"Chicago","Clothing","Need Supply","More",null,null,null,null,null,null,null,"Iowa","Groceries","Need Supply","More"]
[null,null,"Shoes","Stocked","Less",null,null,null,null,null,null,null,null,"Electronic Products","Stocked","Average"]
[null,null,"Jewelry","Stocked","Average",null,null,null,null,null,null,null,null,"Apparel","Stocked","Less"]

{"sheet":"ii. Conditional Formatting","index":2,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,6,1],[7,1,9,1],[10,1,12,1],[1,12,1,15],[4,12,6,12],[7,12,9,12],[10,12,12,12]]}
[]
[null,"Excel Formula to Change Cell Color Based on Text",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Location","Inventory Item","Status","Demand",null,null,null,null,null,null,null,"Location","Inventory Item","Status","Demand"]
[null,"New York","Clothing","Stocked","More",null,null,null,null,null,null,null,"Florida","Groceries","Stocked","Less"]
[null,null,"Shoes","Need Supply","Average",null,null,null,null,null,null,null,null,"Electronic Products","Need Supply","More"]
[null,null,"Jewelry","Need Supply","Less",null,null,null,null,null,null,null,null,"Apparel","Need Supply","Average"]
[null,"Los Angeles","Clothing","Stocked","Less",null,null,null,null,null,null,null,"New Mexico","Groceries","Stocked","More"]
[null,null,"Shoes","Need Supply","More",null,null,null,null,null,null,null,null,"Electronic Products","Need Supply","Less"]
[null,null,"Jewelry","Need Supply","Average",null,null,null,null,null,null,null,null,"Apparel","Need Supply","Average"]
[null,"Chicago","Clothing","Need Supply","More",null,null,null,null,null,null,null,"Iowa","Groceries","Need Supply","More"]
[null,null,"Shoes","Stocked","Less",null,null,null,null,null,null,null,null,"Electronic Products","Stocked","Average"]
[null,null,"Jewelry","Stocked","Average",null,null,null,null,null,null,null,null,"Apparel","Stocked","Less"]

{"sheet":"Find & Replace","index":3,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,6,1],[7,1,9,1],[10,1,12,1],[1,12,1,15],[4,12,6,12],[7,12,9,12],[10,12,12,12]]}
[]
[null,"Excel Formula to Change Cell Color Based on Text",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Location","Inventory Item","Status","Demand",null,null,null,null,null,null,null,"Location","Inventory Item","Status","Demand"]
[null,"New York","Clothing","Stocked","More",null,null,null,null,null,null,null,"Florida","Groceries","Stocked","Less"]
[null,null,"Shoes","Need Supply","Average",null,null,null,null,null,null,null,null,"Electronic Products","Need Supply","More"]
[null,null,"Jewelry","Need Supply","Less",null,null,null,null,null,null,null,null,"Apparel","Need Supply","Average"]
[null,"Los Angeles","Clothing","Stocked","Less",null,null,null,null,null,null,null,"New Mexico","Groceries","Stocked","More"]
[null,null,"Shoes","Need Supply","More",null,null,null,null,null,null,null,null,"Electronic Products","Need Supply","Less"]
[null,null,"Jewelry","Need Supply","Average",null,null,null,null,null,null,null,null,"Apparel","Need Supply","Average"]
[null,"Chicago","Clothing","Need Supply","More",null,null,null,null,null,null,null,"Iowa","Groceries","Need Supply","More"]
[null,null,"Shoes","Stocked","Less",null,null,null,null,null,null,null,null,"Electronic Products","Stocked","Average"]
[null,null,"Jewelry","Stocked","Average",null,null,null,null,null,null,null,null,"Apparel","Stocked","Less"]

{"sheet":"VBA Code","index":4,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,6,1],[7,1,9,1],[10,1,12,1],[1,12,1,15],[4,12,6,12],[7,12,9,12],[10,12,12,12]]}
[]
[null,"Excel Formula to Change Cell Color Based on Text",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Location","Inventory Item","Status","Demand",null,null,null,null,null,null,null,"Location","Inventory Item","Status","Demand"]
[null,"New York","Clothing","Stocked","More",null,null,null,null,null,null,null,"Florida","Groceries","Stocked","Less"]
[null,null,"Shoes","Need Supply","Average",null,null,null,null,null,null,null,null,"Electronic Products","Need Supply","More"]
[null,null,"Jewelry","Need Supply","Less",null,null,null,null,null,null,null,null,"Apparel","Need Supply","Average"]
[null,"Los Angeles","Clothing","Stocked","Less",null,null,null,null,null,null,null,"New Mexico","Groceries","Stocked","More"]
[null,null,"Shoes","Need Supply","More",null,null,null,null,null,null,null,null,"Electronic Products","Need Supply","Less"]
[null,null,"Jewelry","Need Supply","Average",null,null,null,null,null,null,null,null,"Apparel","Need Supply","Average"]
[null,"Chicago","Clothing","Need Supply","More",null,null,null,null,null,null,null,"Iowa","Groceries","Need Supply","More"]
[null,null,"Shoes","Stocked","Less",null,null,null,null,null,null,null,null,"Electronic Products","Stocked","Average"]
[null,null,"Jewelry","Stocked","Average",null,null,null,null,null,null,null,null,"Apparel","Stocked","Less"]