{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Prénom","Date de naissance","Age","Annonce","A souhaiter  dans"]
[1,"2000-05-25",{"$f":"DATEDIF(B2,TODAY(),\"y\")","v":15},{"$f":"IF(E2<2,\"JOYEUX ANNIVERSAIRE\",IF(E2<6,\"Je vous souhaite\",IF(E2<11,\"Bientôt\",\"\")))","v":""},{"$f":"DATEDIF(TODAY(),EDATE(B2,(DATEDIF(B2,TODAY(),\"y\")+1)*12),\"yd\")","v":337}]
[2,"2010-06-25",44,{"$f":"IF(E3=0,\"JOYEUX ANNIVERSAIRE\",IF(E3<6,\"Je vous souhaite\",IF(E3<11,\"Bientôt\",\"\")))","v":"Je vous souhaite"},{"$f":"DATEDIF(TODAY(),EDATE(B3,(DATEDIF(B3,TODAY(),\"y\")+1)*12),\"yd\")","v":2}]
[3,"1997-06-27",17,{"$f":"IF(E4=0,\"JOYEUX ANNIVERSAIRE\",IF(E4<6,\"Je vous souhaite\",IF(E4<11,\"Bientôt\",\"\")))","v":"Je vous souhaite"},4]
[4,"1990-06-29",24,"Bientôt",6]
[5,"1950-06-24",64,{"$f":"IF(E6=0,\"JOYEUX ANNIVERSAIRE\",IF(E6<6,\"Je vous souhaite\",IF(E6<11,\"Bientôt\",\"\")))","v":"Je vous souhaite"},1]
[6,"1977-06-23",38,{"$f":"IF(E7=0,\"JOYEUX ANNIVERSAIRE\",IF(E7<6,\"Je vous souhaite\",IF(E7<11,\"Bientôt\",\"\")))","v":"JOYEUX ANNIVERSAIRE"},0]
[7,"1985-06-29",29,"Bientôt",6]
[]
[null,null,null,null,null,null,null,null,"Je voudrais une alarme clignotante verte pour age compris entre 20  et 30 ans,  orange entre 40 et 50 ans et  rouge >60"]
[null,null,null,null,null,null,null,null,"J'ai tenté  la formule:  =ET(VarEclairage;C2>20)  pour MFC"]
[]
[null,null,null,null,null,null,null,null,"Egalement si possible une cellule clignotante JOYEUX ANNIVERSAIRE en rouge "]
[null,null,null,null,null,null,null,null,"=ET(VarEclairage;D=\"JOYEUX ANNIVERSAIRE\"'",null,null,"SAIRE\")"]

{"sheet":"Feuil2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}