{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Conditional Format","New Rule","Equal Operator","EXACT","SEARCH","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":"Conditional Format","index":0,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,8,1,9],[1,1,1,2]]}
[]
[null,"Using Highlight Cells Rules",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Sales Person Full Name","First Name",null,null,null,null,null,"Sales Person Full Name","First Name"]
[null,"Daniel Smith","Daniel",null,null,null,null,null,"Daniel Smith","Daniel"]
[null,"Paul Brown","Paul",null,null,null,null,null,"Paul Brown","Paul"]
[null,"George Garcia","George",null,null,null,null,null,"George Garcia","George"]
[null,"Steven Williams","Steven",null,null,null,null,null,"Steven Williams","Steven"]
[null,"Bill Jones","Bill Jones",null,null,null,null,null,"Bill Jones","Bill Jones"]
[null,"Bernard Davis","Bernard",null,null,null,null,null,"Bernard Davis","Bernard"]

{"sheet":"New Rule","index":1,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using New Rule",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Sales Person Full Name","First Name",null,null,null,null,null,"Sales Person Full Name","First Name"]
[null,"Daniel Smith","Daniel",null,null,null,null,null,"Daniel Smith","Daniel"]
[null,"Paul Brown","Paul",null,null,null,null,null,"Paul Brown","Paul"]
[null,"George Garcia","George",null,null,null,null,null,"George Garcia","George"]
[null,"Bill Jones","Bill Jones",null,null,null,null,null,"Bill Jones","Bill Jones"]
[null,"Steven Williams","Steven",null,null,null,null,null,"Steven Williams","Steven"]
[null,"Bernard Davis","Bernard",null,null,null,null,null,"Bernard Davis","Bernard"]

{"sheet":"Equal Operator","index":2,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using Equal Operator",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Sales Person Full Name","First Name","Similar",null,null,null,null,null,"Sales Person Full Name","First Name","Similar"]
[null,"Daniel Smith","Daniel",{"$f":"B5=C5","v":false},null,null,null,null,null,"Daniel Smith","Daniel"]
[null,"Paul Brown","Paul",{"$f":"B6=C6","v":false},null,null,null,null,null,"Paul Brown","Paul"]
[null,"George Garcia","George",false,null,null,null,null,null,"George Garcia","George"]
[null,"Bill Jones","Bill Jones",true,null,null,null,null,null,"Bill Jones","Bill Jones"]
[null,"Steven Williams","Steven",false,null,null,null,null,null,"Steven Williams","Steven"]
[null,"Bernard Davis","Bernard",false,null,null,null,null,null,"Bernard Davis","Bernard"]

{"sheet":"EXACT","index":3,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using EXACT Function",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Sales Person Full Name","First Name","Similar",null,null,null,null,null,"Sales Person Full Name","First Name","Similar"]
[null,"Daniel Smith","Daniel",{"$f":"EXACT(B5,C5)","v":false},null,null,null,null,null,"Daniel Smith","Daniel"]
[null,"Paul Brown","Paul",{"$f":"EXACT(B6,C6)","v":false},null,null,null,null,null,"Paul Brown","Paul"]
[null,"George Garcia","George",false,null,null,null,null,null,"George Garcia","George"]
[null,"Bill Jones","Bill Jones",true,null,null,null,null,null,"Bill Jones","Bill Jones"]
[null,"Steven Williams","Steven",false,null,null,null,null,null,"Steven Williams","Steven"]
[null,"Bernard Davis","Bernard",false,null,null,null,null,null,"Bernard Davis","Bernard"]

{"sheet":"SEARCH","index":4,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using SEARCH Function",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Sales Person Full Name","First Name","Similar",null,null,null,null,null,"Sales Person Full Name","First Name","Similar"]
[null,"Daniel Smith","Daniel",{"$f":"IFERROR(IF(SEARCH(C5,B5),\"Similar\"),\"Not Similar\")","v":"Similar"},null,null,null,null,null,"Daniel Smith","Daniel"]
[null,"Paul Brown","Paul",{"$f":"IFERROR(IF(SEARCH(C6,B6),\"Similar\"),\"Not Similar\")","v":"Similar"},null,null,null,null,null,"Paul Brown","Paul"]
[null,"George Garcia","George","Similar",null,null,null,null,null,"George Garcia","George"]
[null,"Bill Jones","Bill Jones","Similar",null,null,null,null,null,"Bill Jones","Bill Jones"]
[null,"Steven Williams","Steven","Similar",null,null,null,null,null,"Steven Williams","Steven"]
[null,"Bernard Davis","Bernard","Similar",null,null,null,null,null,"Bernard Davis","Bernard"]

{"sheet":"VBA","index":5,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using VBA Code",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Sales Person Full Name","First Name",null,null,null,null,null,"Sales Person Full Name","First Name"]
[null,"Daniel Smith","Daniel",null,null,null,null,null,"Daniel Smith","Daniel"]
[null,"Paul Brown","Paul",null,null,null,null,null,"Paul Brown","Paul"]
[null,"George Garcia","George",null,null,null,null,null,"George Garcia","George"]
[null,"Bill Jones","Bill Jones",null,null,null,null,null,"Bill Jones","Bill Jones"]
[null,"Steven Williams","Steven",null,null,null,null,null,"Steven Williams","Steven"]
[null,"Bernard Davis","Bernard",null,null,null,null,null,"Bernard Davis","Bernard"]