{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Use of Formula","Conditional Formatting","VBA"],"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":"Use of Formula","index":0,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9],[10,3,10,4],[10,1,10,2],[10,6,10,7],[10,8,10,9]]}
[]
[null,"Use of Formula to Set Due Date Reminder",null,null,null,null,"Try Yourself"]
[]
[null,"Buyer","Amount","Due Date","Output",null,"Buyer","Amount","Due Date","Output"]
[null,"Oliver",45676,"2022-03-25","Yes",null,"Oliver",45676,"2022-03-25"]
[null,"Luka",89435,"2022-04-12",{"$f":"IF(AND(D6<>\"\",TODAY()+$D$11>=D6),\"Yes\",\"No\")","v":"No"},null,"Luka",89435,"2022-04-12"]
[null,"Aron",78234,"2022-03-27","Yes",null,"Aron",78234,"2022-03-27"]
[null,"Norman",55683,"2022-04-15","No",null,"Norman",55683,"2022-04-15"]
[null,"Brook",93245,"2022-03-29","Yes",null,"Brook",93245,"2022-03-29"]
[]
[null,"Days",null,7,null,null,"Days",null,7]

{"sheet":"Conditional Formatting","index":1,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Apply Conditional Formatting",null,null,null,"Try Yourself"]
[]
[null,"Buyer","Amount","Due Date",null,"Buyer","Amount","Due Date"]
[null,"Oliver",45676,"2022-03-25",null,"Oliver",45676,"2022-03-25"]
[null,"Luka",89435,"2022-04-12",null,"Luka",89435,"2022-04-12"]
[null,"Aron",78234,"2022-03-27",null,"Aron",78234,"2022-03-27"]
[null,"Norman",55683,"2022-04-15",null,"Norman",55683,"2022-04-15"]
[null,"Brook",93245,"2022-03-29",null,"Brook",93245,"2022-03-29"]

{"sheet":"VBA","index":2,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7],[10,1,10,2]]}
[]
[null,"Use of VBA to Get a Pop-Up Alert",null,null,null,"Try Yourself"]
[]
[null,"Buyer","Amount","Due Date",null,"Buyer","Amount","Due Date"]
[null,"Oliver",45676,"2022-03-25",null,"Oliver",45676,"2022-03-25"]
[null,"Luka",89435,"2022-04-12",null,"Luka",89435,"2022-04-12"]
[null,"Aron",78234,"2022-03-27",null,"Aron",78234,"2022-03-27"]
[null,"Norman",55683,"2022-04-15",null,"Norman",55683,"2022-04-15"]
[null,"Brook",93245,"2022-03-29",null,"Brook",93245,"2022-03-29"]
[]
[null,"Days",null,7]