{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Find and Replace","Manual","VBA Code","Highlight Cells Rules","New Rule","For Practice"],"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":"Dataset","index":0,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Net Payable Salaries of Ten Emplyoees in December, 2022"]
[]
[null,"Name","Designation","Basic Salary ","Medical Expenses ","Bonus ","Total "]
[null,"Julissa Duffy","Chief Technical Officer",3000,125,1310,{"$f":"D5+E5+F5","v":4435}]
[null,"Jasmine Armstrong","Accountant",1500,125,230,{"$f":"D6+E6+F6","v":1855}]
[null,"Dana Charles","Senior Web Developer",1000,125,0,1125]
[null,"Marco Barnett","Senior Ux/Ui Developer",1250,125,0,1375]
[null,"Demarion English","Senior Web Developer",1100,125,230,1455]
[null,"Killian Deleon","Senior Web Developer",700,125,230,1055]
[null,"Titus Rodriguez","Web Developer",750,120,0,870]
[null,"Kelvin Daugherty","Ux/Ui Designer",700,120,0,820]
[null,"Cassidy Ellis","Web Developer",700,120,150,970]
[null,"Kenley Levine","Web Developer",400,80,0,480]

{"sheet":"Find and Replace","index":1,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using Find and Replace Feature"]
[]
[null,"Name","Designation","Basic Salary ","Medical Expenses ","Bonus ","Total "]
[null,"Julissa Duffy","Chief Technical Officer",3000,125,1310,{"$f":"D5+E5+F5","v":4435}]
[null,"Jasmine Armstrong","Accountant",1500,125,230,{"$f":"D6+E6+F6","v":1855}]
[null,"Dana Charles","Senior Web Developer",1000,125,0,1125]
[null,"Marco Barnett","Senior Ux/Ui Developer",1250,125,0,1375]
[null,"Demarion English","Senior Web Developer",1100,125,230,1455]
[null,"Killian Deleon","Senior Web Developer",700,125,230,1055]
[null,"Titus Rodriguez","Web Developer",750,120,0,870]
[null,"Kelvin Daugherty","Ux/Ui Designer",700,120,0,820]
[null,"Cassidy Ellis","Web Developer",700,120,150,970]
[null,"Kenley Levine","Web Developer",400,80,0,480]

{"sheet":"Manual","index":2,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Finding and Replacing Text Color Manually"]
[]
[null,"Name","Designation","Basic Salary ","Medical Expenses ","Bonus ","Total "]
[null,"Julissa Duffy","Chief Technical Officer",3000,125,1310,{"$f":"D5+E5+F5","v":4435}]
[null,"Jasmine Armstrong","Accountant",1500,125,230,{"$f":"D6+E6+F6","v":1855}]
[null,"Dana Charles","Senior Web Developer",1000,125,0,1125]
[null,"Marco Barnett","Senior Ux/Ui Developer",1250,125,0,1375]
[null,"Demarion English","Senior Web Developer",1100,125,230,1455]
[null,"Killian Deleon","Senior Web Developer",700,125,230,1055]
[null,"Titus Rodriguez","Web Developer",750,120,0,870]
[null,"Kelvin Daugherty","Ux/Ui Designer",700,120,0,820]
[null,"Cassidy Ellis","Web Developer",700,120,150,970]
[null,"Kenley Levine","Web Developer",400,80,0,480]

{"sheet":"VBA Code","index":3,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Applying VBA Code"]
[]
[null,"Name","Designation","Basic Salary ","Medical Expenses ","Bonus ","Total "]
[null,"Julissa Duffy","Chief Technical Officer",3000,125,1310,{"$f":"D5+E5+F5","v":4435}]
[null,"Jasmine Armstrong","Accountant",1500,125,230,{"$f":"D6+E6+F6","v":1855}]
[null,"Dana Charles","Senior Web Developer",1000,125,0,1125]
[null,"Marco Barnett","Senior Ux/Ui Developer",1250,125,0,1375]
[null,"Demarion English","Senior Web Developer",1100,125,230,1455]
[null,"Killian Deleon","Senior Web Developer",700,125,230,1055]
[null,"Titus Rodriguez","Web Developer",750,120,0,870]
[null,"Kelvin Daugherty","Ux/Ui Designer",700,120,0,820]
[null,"Cassidy Ellis","Web Developer",700,120,150,970]
[null,"Kenley Levine","Web Developer",400,80,0,480]

{"sheet":"Highlight Cells Rules","index":4,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Changing Text Color with Formula in Excel"]
[]
[null,"Name","Designation","Basic Salary ","Medical Expenses ","Bonus ","Total "]
[null,"Julissa Duffy","Chief Technical Officer",3000,125,1310,{"$f":"D5+E5+F5","v":4435}]
[null,"Jasmine Armstrong","Accountant",1500,125,230,{"$f":"D6+E6+F6","v":1855}]
[null,"Dana Charles","Senior Web Developer",1000,125,0,1125]
[null,"Marco Barnett","Senior Ux/Ui Developer",1250,125,0,1375]
[null,"Demarion English","Senior Web Developer",1100,125,230,1455]
[null,"Killian Deleon","Senior Web Developer",700,125,230,1055]
[null,"Titus Rodriguez","Web Developer",750,120,0,870]
[null,"Kelvin Daugherty","Ux/Ui Designer",700,120,0,820]
[null,"Cassidy Ellis","Web Developer",700,120,150,970]
[null,"Kenley Levine","Web Developer",400,80,0,480]

{"sheet":"New Rule","index":5,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Changing Text Color Based on Value with Excel Formula"]
[]
[null,"Name","Designation","Basic Salary ","Medical Expenses ","Bonus ","Total "]
[null,"Julissa Duffy","Chief Technical Officer",3000,125,1310,{"$f":"D5+E5+F5","v":4435}]
[null,"Jasmine Armstrong","Accountant",1500,125,230,{"$f":"D6+E6+F6","v":1855}]
[null,"Dana Charles","Senior Web Developer",1000,125,0,1125]
[null,"Marco Barnett","Senior Ux/Ui Developer",1250,125,0,1375]
[null,"Demarion English","Senior Web Developer",1100,125,230,1455]
[null,"Killian Deleon","Senior Web Developer",700,125,230,1055]
[null,"Titus Rodriguez","Web Developer",750,120,0,870]
[null,"Kelvin Daugherty","Ux/Ui Designer",700,120,0,820]
[null,"Cassidy Ellis","Web Developer",700,120,150,970]
[null,"Kenley Levine","Web Developer",400,80,0,480]

{"sheet":"For Practice","index":6,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Practice Here"]
[]
[null,"Name","Designation","Basic Salary ","Medical Expenses ","Bonus ","Total "]
[null,"Julissa Duffy","Chief Technical Officer",3000,125,1310,{"$f":"D5+E5+F5","v":4435}]
[null,"Jasmine Armstrong","Accountant",1500,125,230,{"$f":"D6+E6+F6","v":1855}]
[null,"Dana Charles","Senior Web Developer",1000,125,0,1125]
[null,"Marco Barnett","Senior Ux/Ui Developer",1250,125,0,1375]
[null,"Demarion English","Senior Web Developer",1100,125,230,1455]
[null,"Killian Deleon","Senior Web Developer",700,125,230,1055]
[null,"Titus Rodriguez","Web Developer",750,120,0,870]
[null,"Kelvin Daugherty","Ux/Ui Designer",700,120,0,820]
[null,"Cassidy Ellis","Web Developer",700,120,150,970]
[null,"Kenley Levine","Web Developer",400,80,0,480]