{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Filter","Editing","VBA-Fill","Sheet7","VBA Font","Sheet5","Sheet6"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Filter","index":0,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Apply Filters and the Subtotal Function to Count Cells with Specific Text and Fill/Font Color in Excel"]
[]
[null,"Books Name","Status",null,"Count",{"$f":"SUBTOTAL(3,B5:B11)","v":7}]
[null,"The Prince of the Skies","Sold"]
[null,"The Most Precious of Cargoes","Stock-out"]
[null,"The Nightingale","Stock-out"]
[null,"Pippo and Clara","Sold"]
[null,"The Winter Soldier","Unsold"]
[null,"The Regeneration Trilogy","Stock-out"]
[null,"Half of a Yellow Sun","Sold"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]

{"sheet":"Editing","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use the Editing Option to Count Cells with Specific Text and Fill/Font Color in Excel"]
[]
[null,"Books Name","Status"]
[null,"The Prince of the Skies","Sold"]
[null,"The Most Precious of Cargoes","Stock-out"]
[null,"The Nightingale","Stock-out"]
[null,"Pippo and Clara","Sold"]
[null,"The Winter Soldier","Unsold"]
[null,"The Regeneration Trilogy","Stock-out"]
[null,"Half of a Yellow Sun","Sold"]

{"sheet":"VBA-Fill","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Run a VBA Code to Count Cells with Specific Text and \nFill Color in Excel"]
[]
[null,"Books Name","Status",null,"Count cellss","Results"]
[null,"The Prince of the Skies","Sold",null,"The Most Precious of Cargoes",4]
[null,"The Most Precious of Cargoes","Stock-out"]
[null,"The Nightingale","Stock-out"]
[null,"Pippo and Clara","Sold"]
[null,"The Winter Soldier","Unsold"]
[null,"The Regeneration Trilogy","Stock-out"]
[null,"Half of a Yellow Sun","Sold"]
[null,"The Most Precious of Cargoes","Stock-out"]

{"sheet":"Sheet7","index":3,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Run a VBA Code to Count Cells with Specific Text and \nFill Color in Excel"]
[]
[null,"Books Name","Status",null,"Count cellss","Results"]
[null,"The Prince of the Skies","Sold",null,"The Most Precious of Cargoes",4]
[null,"The Most Precious of Cargoes","Stock-out"]
[null,"The Nightingale","Stock-out"]
[null,"Pippo and Clara","Sold"]
[null,"The Winter Soldier","Unsold"]
[null,"The Regeneration Trilogy","Stock-out"]
[null,"Half of a Yellow Sun","Sold"]
[null,"The Most Precious of Cargoes","Stock-out"]

{"sheet":"VBA Font","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Run a VBA Code to Count Cells with Specific Text and \nFont Color in Excel"]
[]
[null,"Books Name","Status",null,"Count Cells","Result"]
[null,"The Prince of the Skies","Sold",null,"The Prince of the Skies",3]
[null,"The Most Precious of Cargoes","Stock-out"]
[null,"The Nightingale","Stock-out"]
[null,"Pippo and Clara","Sold"]
[null,"The Winter Soldier","Unsold"]
[null,"The Regeneration Trilogy","Stock-out"]
[null,"Half of a Yellow Sun","Sold"]

{"sheet":"Sheet5","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Overview to Count Cells with Specific Text and \nFont Color in Excel"]
[]
[null,"Books Name","Status",null,"Count Cells","Result"]
[null,"The Prince of the Skies","Sold",null,"The Prince of the Skies",3]
[null,"The Most Precious of Cargoes","Stock-out"]
[null,"The Nightingale","Stock-out"]
[null,"Pippo and Clara","Sold"]
[null,"The Winter Soldier","Unsold"]
[null,"The Regeneration Trilogy","Stock-out"]
[null,"Half of a Yellow Sun","Sold"]

{"sheet":"Sheet6","index":6,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Sample Data Set to Count Cells with Specific Text and Fill/Font Color in Excel"]
[]
[null,"Books Name","Status",null,"Count"]
[null,"The Prince of the Skies","Sold"]
[null,"The Most Precious of Cargoes","Stock-out"]
[null,"The Nightingale","Stock-out"]
[null,"Pippo and Clara","Sold"]
[null,"The Winter Soldier","Unsold"]
[null,"The Regeneration Trilogy","Stock-out"]
[null,"Half of a Yellow Sun","Sold"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]