{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Debtors"],"not_rendered":{"charts":0,"images":4,"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":"Debtors","index":0,"n_rows":32,"n_cols":22,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,2,3,4]]}
[null,null,"Pizza BI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Macro"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub FixCondFormatDupRules()"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://www.contextures.com/excelconditionalformatproblem.html",null,"Dim ws As Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dim MyList As ListObject"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Debra Dalgleish",null,"Dim lRows As Long"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dim rngData As Range"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dim rngRow1 As Range"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dim rngRow2 As Range"]
[null,"Date","Customer","Category","Payment","Payment overdue","Sales","O/S",null,null,null,null,null,null,null,null,null,null,null,null,null,"Dim rngRowLast As Range"]
[null,"2023-08-04","Filippo","New Customer",0,"Yes",100,{"$f":"Debtors[[#This Row],[Sales]]-Debtors[[#This Row],[Payment]]","v":100}]
[null,"2023-08-11","Pietro","Existing Customer",0,"Yes",200,{"$f":"Debtors[[#This Row],[Sales]]-Debtors[[#This Row],[Payment]]","v":200},null,null,null,null,null,null,null,null,null,null,null,null,null,"Set ws = ActiveSheet"]
[null,"2023-08-18","Mario","Existing Customer",50,"Yes",150,{"$f":"Debtors[[#This Row],[Sales]]-Debtors[[#This Row],[Payment]]","v":100},null,null,null,null,null,null,null,null,null,null,null,null,null,"Set MyList = ws.ListObjects(1)"]
[null,"2023-08-21","Bianca","Existing Customer",120,"No",120,{"$f":"Debtors[[#This Row],[Sales]]-Debtors[[#This Row],[Payment]]","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Set rngData = MyList.DataBodyRange"]
[null,"2023-08-25","Alice","New Customer",45,"Yes",130,{"$f":"Debtors[[#This Row],[Sales]]-Debtors[[#This Row],[Payment]]","v":85},null,null,null,null,null,null,null,null,null,null,null,null,null,"lRows = rngData.Rows.Count"]
[null,"2023-09-01","Sofia","New Customer",null,"Yes",99,{"$f":"Debtors[[#This Row],[Sales]]-Debtors[[#This Row],[Payment]]","v":99},null,null,null,null,null,null,null,null,null,null,null,null,null,"Set rngRow1 = rngData.Rows(1)"]
[null,"2023-09-08","Ludovica","Existing Customer",75,"No",75,{"$f":"Debtors[[#This Row],[Sales]]-Debtors[[#This Row],[Payment]]","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Set rngRow2 = rngData.Rows(2)"]
[null,"2023-09-15","Giulia","New Customer",75,"No",150,{"$f":"Debtors[[#This Row],[Sales]]-Debtors[[#This Row],[Payment]]","v":75},null,null,null,null,null,null,null,null,null,null,null,null,null,"Set rngRowLast = rngData.Rows(lRows)"]
[null,"2023-09-22","Beatrice","Existing Customer",125,"No",202,{"$f":"Debtors[[#This Row],[Sales]]-Debtors[[#This Row],[Payment]]","v":77}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"With ws.Range(rngRow2, rngRowLast)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  .FormatConditions.Delete"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End With"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rngRow1.Copy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"With ws.Range(rngRow1, rngRowLast)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  .PasteSpecial Paste:=xlPasteFormats"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End With"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rngRow1.Cells(1, 1).Select"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Application.CutCopyMode = False"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End Sub"]