{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["main","IF","IF INDIRECT","Multi IF","VBA If Statement"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"main","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dynamic Data Validation List in Excel with IF Statement Condition"]
[]
[null,"Color Name","Hex Code","RGB Code"]
[null,"Red","#FF0000","255, 0, 0"]
[null,"Orange","#FFA500","255, 165, 0"]
[null,"Yellow","#FFFF00","255, 255, 0"]
[null,"Lavender","#E6E6FA","230, 230, 250"]
[null,"Lime","#00FF00","0, 255, 0"]
[null,"Blue","#0000FF","0, 0, 255"]
[]
[null,"Color Name","#E6E6FA"]

{"sheet":"IF","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Inserting IF Function",null,null,null,"<<< Practice >>>"]
[]
[null,"Color Name","Hex Code","RGB Code",null,"Color Name","Hex Code","RGB Code"]
[null,"Red","#FF0000","255, 0, 0",null,"Red","#FF0000","255, 0, 0"]
[null,"Orange","#FFA500","255, 165, 0",null,"Orange","#FFA500","255, 165, 0"]
[null,"Yellow","#FFFF00","255, 255, 0",null,"Yellow","#FFFF00","255, 255, 0"]
[null,"Lavender","#E6E6FA","230, 230, 250",null,"Lavender","#E6E6FA","230, 230, 250"]
[null,"Lime","#00FF00","0, 255, 0",null,"Lime","#00FF00","0, 255, 0"]
[null,"Blue","#0000FF","0, 0, 255",null,"Blue","#0000FF","0, 0, 255"]
[]
[null,"Hex Code","#FFFF00"]

{"sheet":"IF INDIRECT","index":2,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Combining IF and INDIRECT Functions",null,null,null,"<<< Practice >>>"]
[]
[null,"Color_Name","Hex_Code","RGB_Code",null,"Color_Name","Hex_Code","RGB_Code"]
[null,"Red","#FF0000","255, 0, 0",null,"Red","#FF0000","255, 0, 0"]
[null,"Orange","#FFA500","255, 165, 0",null,"Orange","#FFA500","255, 165, 0"]
[null,"Yellow","#FFFF00","255, 255, 0",null,"Yellow","#FFFF00","255, 255, 0"]
[null,"Lavender","#E6E6FA","230, 230, 250",null,"Lavender","#E6E6FA","230, 230, 250"]
[null,"Lime","#00FF00","0, 255, 0",null,"Lime","#00FF00","0, 255, 0"]
[null,"Blue","#0000FF","0, 0, 255",null,"Blue","#0000FF","0, 0, 255"]
[]
[null,"RGB_Code","255, 0, 0"]

{"sheet":"Multi IF","index":3,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using Multiple IF Functions",null,null,null,"<<< Practice >>>"]
[]
[null,"Color Name","Hex Code","RGB Code",null,"Color Name","Hex Code","RGB Code"]
[null,"Red","#FF0000","255, 0, 0",null,"Red","#FF0000","255, 0, 0"]
[null,"Orange","#FFA500","255, 165, 0",null,"Orange","#FFA500","255, 165, 0"]
[null,"Yellow","#FFFF00","255, 255, 0",null,"Yellow","#FFFF00","255, 255, 0"]
[null,"Lavender","#E6E6FA","230, 230, 250",null,"Lavender","#E6E6FA","230, 230, 250"]
[null,"Lime","#00FF00","0, 255, 0",null,"Lime","#00FF00","0, 255, 0"]
[null,"Blue","#0000FF","0, 0, 255",null,"Blue","#0000FF","0, 0, 255"]
[]
[null,"Color Name","Yellow"]

{"sheet":"VBA If Statement","index":4,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Applying VBA If Statement",null,null,null,"<<< Practice >>>"]
[]
[null,"Color Name","Hex Code","RGB Code",null,"Color Name","Hex Code","RGB Code"]
[null,"Red","#FF0000","255, 0, 0",null,"Red","#FF0000","255, 0, 0"]
[null,"Orange","#FFA500","255, 165, 0",null,"Orange","#FFA500","255, 165, 0"]
[null,"Yellow","#FFFF00","255, 255, 0",null,"Yellow","#FFFF00","255, 255, 0"]
[null,"Lavender","#E6E6FA","230, 230, 250",null,"Lavender","#E6E6FA","230, 230, 250"]
[null,"Lime","#00FF00","0, 255, 0",null,"Lime","#00FF00","0, 255, 0"]
[null,"Blue","#0000FF","0, 0, 255",null,"Blue","#0000FF","0, 0, 255"]
[]
[null,"Hex Code","#00FF00"]