{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"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":"Feuil1","index":0,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[]
[1,8,10,11,12,15,22,24,29,30,34,35,37,38,45,55,61]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"je n'ai pas mis = dans formule ci-dessous pour l'exple"]
[null,null,null,null,"jaune avec MEFC",null,"NB.SI(($A$3:$Q$3);(E13:I23))",null,null,null,null,null,"jaune colorié avec format cellule remplissage couleur jaune"]
[]
[null,null,null,1,1,2,20,24,29,{"$f":"NbreCellulesCouleur(F13:I13,6)","v":0},null,1,1,2,20,24,29,{"$f":"NbreCellulesCouleur(M13:Q13,6)","v":3}]
[null,null,null,{"$f":"D13+1","v":2},7,8,13,21,28,{"$f":"NbreCellulesCouleur(F14:I14,6)","v":0},null,{"$f":"L13+1","v":2},7,8,13,21,28,{"$f":"NbreCellulesCouleur(M14:Q14,6)","v":1}]
[null,null,null,{"$f":"D14+1","v":3},4,11,14,15,34,0,null,{"$f":"L14+1","v":3},4,11,14,15,34,3]
[null,null,null,{"$f":"D15+1","v":4},5,8,13,19,36,0,null,{"$f":"L15+1","v":4},5,8,13,19,36,2]
[null,null,null,{"$f":"D16+1","v":5},2,10,15,19,36,0,null,{"$f":"L16+1","v":5},2,10,15,19,36,3]
[null,null,null,6,1,7,22,25,28,0,null,6,1,7,22,25,28,2]
[null,null,null,7,1,2,14,27,39,0,null,7,1,2,14,27,39,2]
[null,null,null,8,4,9,11,28,32,0,null,8,4,9,11,28,32,1]
[null,null,null,9,2,4,22,28,29,0,null,9,2,4,22,28,29,2]
[null,null,null,10,1,14,19,24,28,0,null,10,1,14,19,24,28,2]
[null,null,null,11,7,9,14,20,38,0,null,11,7,9,14,20,38,1]
[]
[null,null,null,null,"même fonction NbreCellulesCouleur",null,null,null,null,null,null,null,"Function NbreCellulesCouleur(Plage As Range, Couleur As Byte) As Long"]
[null,null,null,null,null,null,null,null,null,null,null,null,"'Compter le nombre de cellules d'une couleur donnée dans une plage donnée"]
[null,null,null,null,null,null,null,null,null,null,null,null,"'Plage: plage de cellules à inspecter"]
[null,null,null,null,null,null,null,null,null,null,null,null,"'Couleur: valeur de la couleur cherchée"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Application.Volatile"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Dim Cellule As Range"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"For Each Cellule In Plage"]
[null,null,null,null,null,null,null,null,null,null,null,null,"      If Cellule.Interior.ColorIndex = Couleur And Not IsEmpty(Cellule) Then"]
[null,null,null,null,null,null,null,null,null,null,null,null,"        NbreCellulesCouleur = NbreCellulesCouleur + 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,"    End If"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Next Cellule"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"End Function"]