Spreadsheet: 453682d1459410594-is-there-any-way-to-automatically-color-code-cells-based-on-formula-outcome-work-book
Sheet: after

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Co- concedii de odihna |  |  |  |  |  |  |  | I - Invoire si concediu fara retrib
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bo - boala obisnuita |  |  |  |  |  |  |  | O - oblIgatII cetatenestI
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bp - boala profesIonala |  |  |  |  |  |  |  | N - Absente nemotIvate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Am - accIdent de munca |  |  |  |  |  |  |  | Prm - program redus maternItate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M - maternItate |  |  |  |  |  |  |  | Prb - program redus boala
FOAIE COLECTIVA DE PREZENTA (PONTAJ)
 |  |  |  |  |  |  |  |  |  |  |  |  | Luna: _______ |  |  |  |  | 2016-01-01 00:00:00 |  |  |  |  |  | Anul: |  |  | 2016-01-01 00:00:00
Nr crt | [NAME] matrIcol | [NAME] prenumele | [NAME] | ORE ZILNIC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total zile lucrate | dIn care : |  | Total ore lucrate
 |  |  |  | 2016-01-01 00:00:00 | 2016-01-02 00:00:00 | 2016-01-03 00:00:00 | 2016-01-04 00:00:00 | 2016-01-05 00:00:00 | 2016-01-06 00:00:00 | 2016-01-07 00:00:00 | 2016-01-08 00:00:00 | 2016-01-09 00:00:00 | 2016-01-10 00:00:00 | 2016-01-11 00:00:00 | 2016-01-12 00:00:00 | 2016-01-13 00:00:00 | 2016-01-14 00:00:00 | 2016-01-15 00:00:00 | 2016-01-16 00:00:00 | 2016-01-17 00:00:00 | 2016-01-18 00:00:00 | 2016-01-19 00:00:00 | 2016-01-20 00:00:00 | 2016-01-21 00:00:00 | 2016-01-22 00:00:00 | 2016-01-23 00:00:00 | 2016-01-24 00:00:00 | 2016-01-25 00:00:00 | 2016-01-26 00:00:00 | 2016-01-27 00:00:00 | 2016-01-28 00:00:00 | 2016-01-29 00:00:00 | 2016-01-30 00:00:00 | 2016-01-31 00:00:00 |  | ore supl | ore de noapte |  | Co | Bo | Bp | Am | M | I | O | N | Pm | [NAME]
 |  |  |  | 2016-01-01 00:00:00 | 2016-01-02 00:00:00 | 2016-01-03 00:00:00 | 2016-01-04 00:00:00 | 2016-01-05 00:00:00 | 2016-01-06 00:00:00 | 2016-01-07 00:00:00 | 2016-01-08 00:00:00 | 2016-01-09 00:00:00 | 2016-01-10 00:00:00 | 2016-01-11 00:00:00 | 2016-01-12 00:00:00 | 2016-01-13 00:00:00 | 2016-01-14 00:00:00 | 2016-01-15 00:00:00 | 2016-01-16 00:00:00 | 2016-01-17 00:00:00 | 2016-01-18 00:00:00 | 2016-01-19 00:00:00 | 2016-01-20 00:00:00 | 2016-01-21 00:00:00 | 2016-01-22 00:00:00 | 2016-01-23 00:00:00 | 2016-01-24 00:00:00 | 2016-01-25 00:00:00 | 2016-01-26 00:00:00 | 2016-01-27 00:00:00 | 2016-01-28 00:00:00 | 2016-01-29 00:00:00 | 2016-01-30 00:00:00 | 2016-01-31 00:00:00
1 |  | [NAME] IldIco |  | X | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 20 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 |  | Baros Maria |  | X | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 20 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 |  | Berinde Florina |  | X | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 20 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 |  | CrIsan MarIeta Margareta |  | X | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 20 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 |  | Fechete Ana |  | X | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 20 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 |  | Pop [NAME] |  | X | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 20 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 |  | Pop RomelIa Mariana |  | X | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 20 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 |  | SuranI Dominica |  | X | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 20 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
9 |  | SuranI Ioana Andreea |  | X | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 8 | 8 | 8 | 8 | 8 | x | x | 20 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0