{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["1401","1401(an)","Macro1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":2,"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":"1401","index":0,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Excel Magic Trick 1401: Conditionally Format Row For BOLD Date"]
[]
["Many Fun Topics:",null,null,"Remember: To get GET.CELL to recalculate, use keyboard: Ctrl + Alt + F9"]
[1,"GET.CELL Excel 4 Macro Function to determine when a cell has Bold Font."]
[2,"Create Defined Name that can \"read\" Excel 4 Macro Function."]
[3,"See how to create a Mixed Cell Reference in a Defined Name"]
[4,"Use Defined Name Formula in Conditional Formatting Dialog Box"]
[]
["Date","Sales","Product",null,"Bold?"]
["2017-04-02",444,"Quad"]
["2017-04-02",314,"Carlota"]
["2017-04-02",343,"Quad"]
["2017-04-02",357,"Bellen"]
["2017-04-02",795,"Bellen"]
["2017-04-02",867,"Bellen"]
["2017-04-02",274,"Quad"]
["2017-04-02",327,"Carlota"]
["2017-04-02",319,"Carlota"]
["2017-04-02",414,"Quad"]
["2017-04-02",895,"Carlota"]
["2017-04-02",866,"Bellen"]
["2017-04-02",279,"Carlota"]
[]
["Keyboards:"]
["Shift + F11 = Insert a New Sheet"]
["Ctrl + F11 = Insert a New Macro 4.0 Sheet"]
["Ctrl + F3 = Defined Name \"Name Manager\""]
["Ctrl + Alt + F9 = Refresh all open workbooks and sheets"]
["Insert Logical Formula into Conditional Formatting dialog box: Alt, H, L, N, PageDown, Tab, Ctrl + V"]

{"sheet":"1401(an)","index":1,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Excel Magic Trick 1401: Conditionally Format Row For BOLD Date"]
[]
["Many Fun Topics:",null,null,"Remember: To get GET.CELL to recalculate, use keyboard: Ctrl + Alt + F9"]
[1,"GET.CELL Excel 4 Macro Function to determine when a cell has Bold Font."]
[2,"Create Defined Name that can \"read\" Excel 4 Macro Function."]
[3,"See how to create a Mixed Cell Reference in a Defined Name"]
[4,"Use Defined Name Formula in Conditional Formatting Dialog Box"]
[]
["Date","Sales","Product",null,"Bold?"]
["2017-04-02",444,"Quad",null,{"$f":"IsBoldAnswer","v":false},{"$f":"IsBoldAnswer","v":false},{"$f":"IsBoldAnswer","v":false}]
["2017-04-02",314,"Carlota",null,{"$f":"IsBoldAnswer","v":false},{"$f":"IsBoldAnswer","v":false},{"$f":"IsBoldAnswer","v":false}]
["2017-04-02",343,"Quad",null,{"$f":"IsBoldAnswer","v":true},{"$f":"IsBoldAnswer","v":true},{"$f":"IsBoldAnswer","v":true}]
["2017-04-02",357,"Bellen",null,{"$f":"IsBoldAnswer","v":true},{"$f":"IsBoldAnswer","v":true},{"$f":"IsBoldAnswer","v":true}]
["2017-04-02",795,"Bellen",null,{"$f":"IsBoldAnswer","v":false},{"$f":"IsBoldAnswer","v":false},{"$f":"IsBoldAnswer","v":false}]
["2017-04-02",867,"Bellen",null,{"$f":"IsBoldAnswer","v":false},{"$f":"IsBoldAnswer","v":false},{"$f":"IsBoldAnswer","v":false}]
["2017-04-02",274,"Quad",null,{"$f":"IsBoldAnswer","v":false},{"$f":"IsBoldAnswer","v":false},{"$f":"IsBoldAnswer","v":false}]
["2017-04-02",327,"Carlota",null,{"$f":"IsBoldAnswer","v":false},{"$f":"IsBoldAnswer","v":false},{"$f":"IsBoldAnswer","v":false}]
["2017-04-02",319,"Carlota",null,{"$f":"IsBoldAnswer","v":true},{"$f":"IsBoldAnswer","v":true},{"$f":"IsBoldAnswer","v":true}]
["2017-04-02",414,"Quad",null,{"$f":"IsBoldAnswer","v":false},{"$f":"IsBoldAnswer","v":false},{"$f":"IsBoldAnswer","v":false}]
["2017-04-02",895,"Carlota",null,{"$f":"IsBoldAnswer","v":false},{"$f":"IsBoldAnswer","v":false},{"$f":"IsBoldAnswer","v":false}]
["2017-04-02",866,"Bellen",null,{"$f":"IsBoldAnswer","v":true},{"$f":"IsBoldAnswer","v":true},{"$f":"IsBoldAnswer","v":true}]
["2017-04-02",279,"Carlota",null,{"$f":"IsBoldAnswer","v":false},{"$f":"IsBoldAnswer","v":false},{"$f":"IsBoldAnswer","v":false}]
[]
["Keyboards:"]
["Shift + F11 = Insert a New Sheet"]
["Ctrl + F11 = Insert a New Macro 4.0 Sheet"]
["Ctrl + F3 = Defined Name \"Name Manager\""]
["Ctrl + Alt + F9 = Refresh all open workbooks and sheets"]
["Insert Logical Formula into Conditional Formatting dialog box: Alt, H, L, N, PageDown, Tab, Ctrl + V"]

{"sheet":"Macro1","index":2,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Date"]
["2017-04-02",{"$f":"GET.CELL(20,A2)","v":false}]
["2017-04-02",{"$f":"GET.CELL(20,A3)","v":false}]
["2017-04-02",{"$f":"GET.CELL(20,A4)","v":true}]
["2017-04-02",false]
["2017-04-02",false]
["2017-04-02",false]
["2017-04-02",false]
["2017-04-02",false]
["2017-04-02",{"$f":"GET.CELL(20,A10)","v":true}]
["2017-04-02",false]
["2017-04-02",false]
["2017-04-02",false]
["2017-04-02",false]