Spreadsheet: 682417d1592078066-can-i-collor-one-week-2-cells-and-other-week-3-with-conditional-formating-voorwaardelijk-opmaak-probleem
Sheet: Afwzeigheid Sjabloon

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aantal | Totaal /vermindering dagen |  |  |  | Aantal
 | Ma | Di | Wo | Do | Vr | Za | Zo |  |  | Ma | Di | Wo | Do | Vr | Za | Zo |  |  |  |  |  | Verlofdagen afhankelijk leetijd |  |  | 25 |  | Aantal [NAME] [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] [NAME] |  |  |  |  | Aantal dagen werkongeval van voor [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kredietdagen opgespaard vorige jaren |  |  | 35 |  | Totaal aantal ziekte dagen vorige jaren +huidig jaar
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Kredietdagen huidig jaar |  |  | 13 |  | Totaal Aantal dagen werkongeval vorige jaren + huidig jaar
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PERIODE |  | Collectieve verlofdagen  [NAME] |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vermindering CV =totaal ziek + werkongeval + staking
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Soort te werkstelling |  | Voltijds
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PERIODE |  | Vrijedag bij 4/5 | Maandag
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aantal genomen |  | Aantal te nemen dit [NAME] |  | Aantal vorig jaar |  | donderdag | vrijdag
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VERLOF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WERK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZIEK |  |  |  | Datum [NAME] | Waardoor ziek
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OP WERK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SOCIALE PROMOTIE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GELEGENHEIDSVERLOF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DIENSTVRIJSTELLING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZENDING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WERKONGEVAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STAKING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VERLOF VORIG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JAAR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VERLOF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4/5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEESTDAGEN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZAT-EN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZONDAGEN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AG | VANDAAG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SLUITING
 |  |  |  | © | Daelman G
 | SCHOOLVAKANTIES
 |  |  |  | Begint  op |  |  |  | eindigt op
 | Zomervakentie
 | [NAME]
 | Kerstvakantie
 | Krokusvakantie
 | Paasvakantie
 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =VERT.ZOEKEN(e4,Feestdagen,1,0)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EN(TEKST(E5,"[$-813]DDDD")=$X$10,1)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =en(TEKST(B5,"[$-813]DDDD")=$X$10, niet (VERT.ZOEKEN(B5,Feestdagen,1,0)))