Spreadsheet: 684265d1593246884-conditional-formatting-two-conditions-conditional-formating
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =MATCH(S$10;$BD$26:$BD$36;0)>0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =MATCH(Q$10:AU$10;$BB$12:$BB$17;0)>0
number | surname and name |  | Annal leave | left | first part |  | Drugi dio |  | Treći dio |  | Četvrti dio |  | JUN 2020
 |  |  |  |  | Od | Do | Od | Do | Od | Do | Od | Do | 2020-06-01 00:00:00 | 2020-06-02 00:00:00 | 2020-06-03 00:00:00 | 2020-06-04 00:00:00 | 2020-06-05 00:00:00 | 2020-06-06 00:00:00 | 2020-06-07 00:00:00 | 2020-06-08 00:00:00 | 2020-06-09 00:00:00 | 2020-06-10 00:00:00 | 2020-06-11 00:00:00 | 2020-06-12 00:00:00 | 2020-06-13 00:00:00 | 2020-06-14 00:00:00 | 2020-06-15 00:00:00 | 2020-06-16 00:00:00 | 2020-06-17 00:00:00 | 2020-06-18 00:00:00 | 2020-06-19 00:00:00 | 2020-06-20 00:00:00 | 2020-06-21 00:00:00 | 2020-06-22 00:00:00 | 2020-06-23 00:00:00 | 2020-06-24 00:00:00 | 2020-06-25 00:00:00 | 2020-06-26 00:00:00 | 2020-06-27 00:00:00 | 2020-06-28 00:00:00 | 2020-06-29 00:00:00 | 2020-06-30 00:00:00
1. | AHMET | FO | 25 |  | 06.07.2020. | 17.07.2020.
2. | ALEX | RS | 29 |  | 20.07.2020. | 31.07.2020.
3. | ASCO | RS | 29 |  | 31.08.2020. | 11.09.2020.
4. | AVEL | RS | 30 |  | 10.08.2020. | 21.08.2020.
5. | BABO | FO | 29 |  | 06.07.2020. | 17.07.2020.
6. | BADGE | RS | 30 |  | 22.06.2020. | 03.07.2020.
7. | BAJ | RS | 29 |  | 14.09.2020. | 25.09.2020.
8. | BAJR | FO | 23 |  | 28.09.2020. | 09.10.2020.
9. | BARO | FO | 30 |  | 03.08.2020. | 14.08.2020.
10. | BJELI | RS | 18 |  | 22.06.2020. | 03.07.2020.
11. | BOGD | RS | 24 |  | 14.09.2020. | 25.09.2020.
12. | BOGI | RS | 29 |  | 31.08.2020. | 11.09.2020.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOLIDAYS |  | HOLIDAYS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RS |  | FO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-11-21 00:00:00 |  | 2020-11-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-01-01 00:00:00 |  | 2021-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-01-02 00:00:00 |  | 2021-01-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-01 00:00:00 |  | 2021-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-02 00:00:00 |  | 2021-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-09 00:00:00 |  | 2021-05-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-06-03 00:00:00 |  | 2020-06-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-06-01 00:00:00 |  | 2020-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-06-03 00:00:00