Bonjour,Bonjour à tous,
Tu sélectionnes la colonne des dates ex: A2:A100
Accueil/mise en forme conditionnelle/nouvelle règle/ ajouter une formule
=année($A2)=2021
s'applique à: $A$2:$A$100
Si problème peux-tu nous joindre un petit extrait de fichier.
JHA
10/11/2021 | 15:15 | 15:20 | 00:05 | 25/11/2021 | 15:15 | 15:20 | 00:05 | 03/01/2022 | 15:15 | 15:25 | 00:10 | 27/01/2022 | 11:35 | 11:45 | 00:10 |
10/11/2021 | 15:20 | 15:25 | 00:05 | 25/11/2021 | 15:20 | 15:30 | 00:10 | 03/01/2022 | 15:25 | 15:35 | 00:10 | 27/01/2022 | 11:45 | 11:50 | 00:05 |
10/11/2021 | 15:25 | 15:30 | 00:05 | 03/01/2022 | 15:00 | 15:15 | 00:15 | 27/01/2022 | 11:50 | 11:55 | 00:05 | 00:00 | |||
10/11/2021 | 15:30 | 15:40 | 00:10 | 03/01/2022 | 15:15 | 15:30 | 00:15 | 27/01/2022 | 11:55 | 12:00 | 00:05 | 00:00 | |||
19/11/2021 | 11:00 | 11:15 | 00:15 | 00:00 | 00:00 | 00:00 | |||||||||
15/11/2021 | 11:00 | 11:15 | 00:15 | 18/11/2021 | 10:45 | 11:00 | 00:15 | 00:00 | 00:00 | ||||||
15/11/2021 | 11:15 | 11:30 | 00:15 | 18/11/2021 | 11:00 | 11:30 | 00:30 | 00:00 | 00:00 | ||||||
05/01/2022 | 14:00 | 14:30 | 00:30 | 03/01/2022 | 15:30 | 15:45 | 00:15 | 07/01/2022 | 12:15 | 12:30 | 00:15 | 00:00 | |||
05/01/2022 | 14:30 | 15:00 | 00:30 | 03/01/2022 | 15:45 | 16:00 | 00:15 | 07/01/2022 | 12:30 | 12:45 | 00:15 | 27/01/2022 | 15:35 | 16:00 | 00:25 |
08/11/2021 | 14:00 | 14:15 | 00:15 | 17/11/2021 | 14:30 | 14:45 | 00:15 | 09/12/2021 | 14:30 | 14:45 | 00:15 | 16/12/2021 | 10:45 | 11:00 | 00:15 |
08/11/2021 | 14:15 | 14:30 | 00:15 | 17/11/2021 | 14:45 | 15:00 | 00:15 | 09/12/2021 | 14:45 | 15:00 | 00:15 | 16/12/2021 | 11:00 | 11:15 | 00:15 |
08/11/2021 | 14:30 | 14:45 | 00:15 | 17/11/2021 | 15:00 | 15:15 | 00:15 | 09/12/2021 | 15:00 | 15:15 | 00:15 | 16/12/2021 | 11:15 | 11:30 | 00:15 |
08/11/2021 | 14:45 | 15:00 | 00:15 | 17/11/2021 | 15:15 | 15:30 | 00:15 | 09/12/2021 | 15:15 | 15:30 | 00:15 | 16/12/2021 | 11:30 | 11:45 | 00:15 |
03/11/2021 | 10:00 | 11:00 | 01:00 | 27/01/2022 | 11:10 | 11:35 | 00:25 | 00:00 | 00:00 | ||||||
18/11/2021 | 10:30 | 10:45 | 00:15 | 00:00 | 00:00 | 00:00 | |||||||||
03/11/2021 | 15:30 | 15:45 | 00:15 | 16/11/2021 | 15:00 | 15:30 | 00:30 | 17/11/2021 | 14:00 | 14:15 | 00:15 | 09/12/2021 | 14:00 | 14:15 | 00:15 |
03/11/2021 | 15:45 | 16:00 | 00:15 | 16/11/2021 | 15:30 | 16:00 | 00:30 | 17/11/2021 | 14:15 | 14:30 | 00:15 | 09/12/2021 | 14:15 | 14:30 | 00:15 |
15/11/2021 | 10:00 | 10:15 | 00:15 | 19/11/2021 | 10:00 | 10:15 | 00:15 | 00:00 | 00:00 | ||||||
15/11/2021 | 10:15 | 10:30 | 00:15 | 19/11/2021 | 10:15 | 10:30 | 00:15 | 00:00 | 00:00 | ||||||
15/11/2021 | 10:30 | 10:45 | 00:15 | 19/11/2021 | 10:30 | 10:45 | 00:15 | 00:00 | 00:00 | ||||||
15/11/2021 | 10:45 | 11:00 | 00:15 | 19/11/2021 | 10:45 | 11:00 | 00:15 | 00:00 | 00:00 | ||||||
27/01/2022 | 11:50 | 12:00 | 00:10 | 00:00 | 00:00 | 00:00 |