Spreadsheet: 760638d1640354196-help-with-complex-conditional-formatting-cf-applied-to-a-power-pivot-table-kyber-
Sheet: PT from PQ Table

 | Name/ID | Face to Face | Over the Phone | Intake Meeting | Name/ID Count | Duration Total
 | [NAME] |  |  |  | 1 | 0
 | [NAME] |  |  |  | 1 | 0
 | Adam Beach - 7197 |  |  |  | 1 | 0
 | [NAME] |  |  |  | 1 | 0
 | Alejandro Abellan - 7881 |  |  |  | 1 | 0
 | [NAME] |  |  |  | 1 | 0
 | [NAME] 250 |  |  |  | 1 | 0
 | [NAME] |  |  |  | 1 | 0
 | [NAME] | 30 |  |  | 1 | 30
 | [NAME] |  | 60 |  | 1 | 60
 | [NAME] | 60 |  |  | 1 | 60
 | [NAME] |  | 60 |  | 1 | 60
 | [NAME] | 60 |  |  | 1 | 60
 | [NAME] |  | 60 |  | 1 | 60
 | [NAME] | 60 |  |  | 1 | 60
 | [NAME] |  | 60 |  | 1 | 60
 | [NAME] | 60 |  |  | 1 | 60
 | [NAME] |  | 60 |  | 1 | 60
 | [NAME] | 60 |  |  | 1 | 60
 | [NAME] |  | 60 |  | 1 | 60
 | Bilal Baig - 2444 | 60 |  |  | 1 | 60
 | [NAME] |  | 60 |  | 1 | 60
 | [NAME] | 60 |  |  | 1 | 60
 | [NAME] |  | 60 |  | 1 | 60
 | [NAME] | 60 |  |  | 1 | 60
 | [NAME] |  | 60 |  | 1 | 60
 | [NAME] | 60 |  |  | 1 | 60
 | [NAME] |  | 60 |  | 1 | 60
 | [NAME] | 60 |  |  | 1 | 60
 | [NAME] 7555 |  | 60 |  | 1 | 60
 | [NAME] | 60 |  |  | 1 | 60
 | [NAME] |  | 60 |  | 1 | 60
 | Caroline Azar - 8550 | 60 |  |  | 1 | 60
 | [NAME] |  | 60 |  | 1 | 60
 | [NAME] 6999 | 60 |  |  | 1 | 60
 | [NAME] |  | 60 |  | 1 | 60
 | [NAME] | 60 |  |  | 1 | 60
 | [NAME] |  | 60 |  | 1 | 60
 | [NAME] | 60 |  |  | 1 | 60
 | [NAME] |  | 60 |  | 1 | 60
 | [NAME] | 60 |  |  | 1 | 60
 | [NAME] |  | 60 |  | 1 | 60
 | Clyde Alves - 4807 | 60 |  |  | 1 | 60
 | [NAME] |  | 60 |  | 1 | 60
 | [NAME] | 60 |  |  | 1 | 60
 | [NAME] |  | 60 |  | 1 | 60
 | [NAME] | 60 |  |  | 1 | 60
 | [NAME] 5794 |  | 60 |  | 1 | 60
 | [NAME] 1854 | 60 |  |  | 1 | 60
 | [NAME] |  | 60 |  | 1 | 60
 | [NAME] | 60 |  | 120 | 2 | 180
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] 5004 |  | 75 |  | 2 | 75
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 60 | 180 | 2 | 240
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 60 | 60 | 2 | 120
 | Demore Barnes - 8097 | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | Denys Arcand - 5878 | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] - 2222 | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | Emilie-[NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | Fajer Al-Kaisi - 857 | 120 |  |  | 2 | 120
 | Frances Bay - 340 |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] 7011 | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] 5151 |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | Lilly Bartlam - 505 |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | Marc Akerstream - 6454 | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] 4636 | 120 |  |  | 2 | 120
 | [NAME] der Maur - 126 |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 90 |  | 2 | 90
 | [NAME] | 90 |  |  | 2 | 90
 | [NAME] |  | 90 |  | 2 | 90
 | [NAME] | 90 |  |  | 2 | 90
 | [NAME] |  | 90 |  | 2 | 90
 | [NAME] | 90 |  |  | 2 | 90
 | [NAME] |  | 90 |  | 2 | 90
 | [NAME] | 90 |  |  | 2 | 90
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] 1665 |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | Rudwan Khalil Abubaker - 7488 |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | Shawn Ashmore - 7113 | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] 2987 | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 120 |  | 2 | 120
 | [NAME] | 120 |  |  | 2 | 120
 | [NAME] |  | 160 |  | 2 | 160
 | [NAME] | 160 |  |  | 2 | 160
 | [NAME] |  | 160 |  | 2 | 160
 | [NAME] | 200 |  |  | 2 | 200
 | [NAME] |  | 240 |  | 2 | 240
 | Grand Total | 10170 | 10175 | 360 | 350 | 20705