Spreadsheet: 536691d1504637491-conditional-formatting-with-multiple-matching-criteria-book1
Sheet: Sheet1

# | Plt Date | OGM Date | S | D | D/T | Name | GMIN |  |  |  |  | Employee Class | Reg/Temp |  |  | Name | Badge | Shift | Dept | Team | GMIN | H / S | Last Name | First Name | Last Purchase Date | Old Badge1
1 | 1957-02-19 00:00:00 | 1957-02-19 00:00:00 | 1 | 27 | 27D1 |  | 317101601 |  |  |  |  | Regular | Regular |  |  | [NAME] | 13118690 | 1 | 71 | I | 318113857 | H | Aarstad | [NAME]
2 | 1965-08-01 00:00:00 | 1965-08-01 00:00:00 | 3 | 45 | 45A1 |  | 13108578 |  |  |  |  | Per Diem | Regular |  |  | [NAME] | 10505016 | 2 | 45 | A | 557693387 | H | Abbass | Adel
3 | 1965-08-09 00:00:00 | 1965-08-09 00:00:00 | 1 | 46 | 46A1 |  | 917178532 |  |  |  |  | Regular | Regular |  |  | [NAME] | 10517217 | 2 | 19 | C | 137626249 | H | [NAME] | [NAME]
4 | 1967-06-19 00:00:00 | 1967-06-19 00:00:00 | 1 | 73 | 73A1 |  | 315152538 |  |  |  |  | Regular | Regular |  |  | [NAME] | 13210419 | 1 | 11 | T | 318123233 | H | Adams | [NAME]
5 | 1967-08-21 00:00:00 | 1967-08-21 00:00:00 | 1 | 03 | 03A1 |  | 816132470 |  |  |  |  | Regular | Regular |  |  | [NAME] | 12345657 | 1 | 50 | T | 253717293 | S | Admire | [NAME]
6 | 1967-09-05 00:00:00 | 1967-09-05 00:00:00 | 1 | 15 | 15C1 |  | 219107724 |  |  |  |  | Regular | Regular |  |  | [NAME] | 13328845 | 1 | 44 | A | 610794610 | S | Alameda | [NAME]
7 | 1967-09-08 00:00:00 | 1967-09-08 00:00:00 | 1 | 71 | 71A1 |  | 402368 |  |  |  |  | Per Diem | Regular |  |  | [NAME] | 10514106 | 2 | 44 | A | 786236955 | H | [NAME] | Gregory
8 | 1967-09-25 00:00:00 | 1967-09-25 00:00:00 | 1 | 71 | 71A1 |  | 419122036 |  |  |  |  | Regular | Regular |  |  | [NAME] | 25025075 | 2 | 15 | C | 571129916 | S | Alcoe | [NAME]
9 | 1967-10-09 00:00:00 | 1967-10-09 00:00:00 | 1 | 27 | 27D1 |  | 417169715 |  |  |  |  | Regular | Regular |  |  | [NAME] | 20429524 | 1 | 44 | A | 412140268 | S | [NAME] | [NAME]
10 | 1967-11-02 00:00:00 | 1967-11-02 00:00:00 | 2 | 03 | 03A1 |  | 618114175 |  |  |  |  | Regular | Regular |  |  | [NAME] | 20714509 | 1 | 15 | D | 861657580 | S | [NAME] | [NAME]
11 | 1967-11-13 00:00:00 | 1967-11-13 00:00:00 | 1 | 27 | 27R1 |  | 13210419 |  |  |  |  | Per Diem | Regular |  |  | [NAME] | 13204200 | 3 | 19 | G | 782877436 | H | [NAME] | Ernest
12 | 1967-11-13 00:00:00 | 1967-11-13 00:00:00 | 3 | 03 | 03A1 |  | 814108364 |  |  |  |  | Regular | Regular |  |  | [NAME] | 13214502 | 1 | 71 | C | 315153431 | H | [NAME] | Ray
13 | 1968-03-04 00:00:00 | 1968-03-04 00:00:00 | 1 | 71 | 71A1 |  | 214150005 |  |  |  |  | Regular | Regular |  |  | [NAME] | 13108578 | 2 | 87 | B | 315159044 | H | Amschler | [NAME]
14 | 1968-04-09 00:00:00 | 1968-04-09 00:00:00 | 1 | 73 | 73A1 |  | 613107638 |  |  |  |  | Regular | Regular |  |  | [NAME] | 17424602 | 3 | 15 | D | 439357930 | H | [NAME] | [NAME]
15 | 1968-04-11 00:00:00 | 1968-04-11 00:00:00 | 1 | 27 | 27E1 |  | 517155863 |  |  |  |  | Regular | Regular |  |  | [NAME] | 10522130 | 1 | 25 | H | 713140657 | H | [NAME] | [NAME]
16 | 1968-05-08 00:00:00 | 1968-05-08 00:00:00 | 1 | 71 | 71C1 |  | 413567 |  |  |  |  | Per Diem | Regular |  |  | [NAME] | 13108609 | 1 | 30 | G | 715131826 | H | [NAME] | [NAME]
17 | 1968-09-06 00:00:00 | 1968-09-06 00:00:00 | 1 | 51 | 51D1 |  | 914136972 |  |  |  |  | Regular | Regular |  |  | [NAME] | 13113871 | 2 | 44 | C | 719194749 | H | [NAME] | [NAME]
18 | 1968-09-11 00:00:00 | 1968-09-11 00:00:00 | 3 | 03 | 03A1 |  | 819120186 |  |  |  |  | Regular | Regular |  |  | [NAME] | 413567 | 3 | 45 | A | 668528493 | S | Aponte | Nester
19 | 1968-09-16 00:00:00 | 1968-09-16 00:00:00 | 2 | 50 | 50B1 |  | 914150914 |  |  |  |  | Regular | Regular |  |  | [NAME] | 13105098 | 1 | 15 | D | 613119649 | H | [NAME] | Dennis
20 | 1968-09-30 00:00:00 | 1968-09-30 00:00:00 | 3 | 03 | 03A1 |  | 13115031 |  |  |  |  | Per Diem | Regular |  |  | [NAME] | 402368 | 1 | 50 | Z | 218174512 | S | [NAME] | [NAME]
21 | 1968-10-01 00:00:00 | 1968-10-01 00:00:00 | 3 | 51 | 51D1 |  | 215161342 |  |  |  |  | Regular | Regular |  |  | [NAME] | 13130984 | 2 | 19 | B | 532438929 | H | Ashcraft | [NAME]
22 | 1969-05-28 00:00:00 | 1969-05-28 00:00:00 | 2 | 51 | 51D1 |  | 315172826 |  |  |  |  | Regular | Regular |  |  | [NAME] | 13214044 | 3 | 11 | S | 617182793 | H | Asher | Todd
23 | 1969-06-17 00:00:00 | 1969-06-17 00:00:00 | 1 | 27 | 27D1 |  | 516130629 |  |  |  |  | Regular | Regular |  |  | [NAME] | 13115031 | 2 | 46 | A | 219102850 | H | Atkinson | Dennis
24 | 1969-06-26 00:00:00 | 1969-06-26 00:00:00 | 1 | 03 | 03A1 |  | 719180804 |  |  |  |  | Regular | Regular |  |  | [NAME] | 10727864 | 3 | 45 | A | 213194093 | H | Atwood | Butch
25 | 1969-06-28 00:00:00 | 1969-06-28 00:00:00 | 2 | 11 | 11F1 |  | 10711626 |  |  |  |  | Per Diem | Regular |  |  | [NAME] | 17410085 | 3 | 15 | D | 618177435 | H | [NAME] | Eddie
26 | 1969-07-29 00:00:00 | 1969-07-29 00:00:00 | 1 | 27 | 27E1 |  | 713181896 |  |  |  |  | Regular | Regular |  |  | [NAME] | 13127903 | 2 | 51 | A | 315172826 | H | [NAME] | [NAME]
27 | 1969-07-29 00:00:00 | 1969-07-29 00:00:00 | 3 | 25 | 25F1 |  | 519164788 |  |  |  |  | Regular | Regular |  |  | [NAME] | 13131713 | 2 | 71 | D | 854856255 | H | [NAME] | [NAME]
28 | 1969-08-11 00:00:00 | 1969-08-11 00:00:00 | 1 | 27 | 27D1 |  | 718149937 |  |  |  |  | Regular | Regular |  |  | [NAME] | 10711626 | 2 | 45 | A | 915167689 | S | Avery | [NAME] |  | 6314374
29 | 1969-08-20 00:00:00 | 1969-08-20 00:00:00 | 1 | 30 | 30A1 |  | 715189294 |  |  |  |  | Regular | Regular |  |  | Christie Bacon | 10506404 | 2 | 19 | G | 325807903 | H | Bacon | Chistie
30 | 1969-09-05 00:00:00 | 1969-09-05 00:00:00 | 2 | 11 | 11E1 |  | 13108587 |  |  |  |  | Per Diem | Regular |  |  | [NAME] | 13108587 | 2 | 46 | A | 514117554 | H | Baines | [NAME] |  | 13115033
I am expecting Q5, Q14, Q19, [NAME], Q24, Q29 & Q31 to be highlighted.