Spreadsheet: 140022d1328595818-how-do-i-conditional-format-a-row-with-reference-from-column-manhours-extraction-solution-
Sheet: Input

Project | Type | Department | Name | SAP | Time | Month | Days
BO-620 | Commercial | Hull | [NAME] | 30001863 | Normal Time | 2008-06-01 00:00:00 | 21
BO-620 | Commercial | Hull | [NAME] | 30001863 | Normal Time | 2008-07-01 00:00:00 | 23
BO-620 | Commercial | Hull | [NAME] | 30001863 | Normal Time | 2008-08-01 00:00:00 | 20
BO-620 | Commercial | Hull | [NAME] | 30001863 | Normal Time | 2008-09-01 00:00:00 | 22
BO-620 | Commercial | Hull | [NAME] | 30001863 | Normal Time | 2008-10-01 00:00:00 | 22
BO-620 | Commercial | Hull | [NAME] | 30001863 | Normal Time | 2008-11-01 00:00:00 | 20
BO-620 | Commercial | Hull | [NAME] | 30001863 | Normal Time | 2008-12-01 00:00:00 | 11
BO-620 | Commercial | Hull | [NAME] | 30001863 | Normal Time | 2009-01-01 00:00:00 | 10
BO-620 | Commercial | Hull | [NAME] | 30001863 | Normal Time | 2009-02-01 00:00:00 | 10
BO-620 | Commercial | Hull | [NAME] | 30001863 | Normal Time | 2009-03-01 00:00:00 | 11
BO-620 | Commercial | Hull | [NAME] | 30001863 | Normal Time | 2009-04-01 00:00:00 | 11
BO-620 | Commercial | Hull | [NAME] | 30001863 | Normal Time | 2009-05-01 00:00:00 | 10
BO-620 | Commercial | Hull | [NAME] | 30001863 | Normal Time | 2009-06-01 00:00:00 | 11
BO-620 | Commercial | Hull | [NAME] | 30001863 | Normal Time | 2009-07-01 00:00:00 | 12
BO-620 | Commercial | Hull | [NAME] | 30001863 | Normal Time | 2009-08-01 00:00:00 | 10
BO-620 | Commercial | Hull | [NAME] | 30001863 | Normal Time | 2009-09-01 00:00:00 | 11
BO-620 | Commercial | Hull | [NAME] | 30001863 | Overtime | 2008-06-01 00:00:00 | 2
BO-620 | Commercial | Hull | [NAME] | 30001863 | Overtime | 2008-08-01 00:00:00 | 1
BO-620 | Commercial | Hull | [NAME] | 30001863 | Overtime | 2008-09-01 00:00:00 | 2
BO-620 | Commercial | Hull | [NAME] | 30001863 | Overtime | 2008-10-01 00:00:00 | 0.5
BO-620 | Commercial | Hull | [NAME] | 30001863 | Overtime | 2008-11-01 00:00:00 | 1
BO-620 | Commercial | Hull | [NAME] | 30001863 | Overtime | 2008-12-01 00:00:00 | 0.5
BO-620 | Commercial | Hull | [NAME] | 30001863 | Overtime | 2009-01-01 00:00:00 | 0.5
BO-620 | Commercial | Hull | [NAME] | 30001863 | Overtime | 2009-02-01 00:00:00 | 2
BO-620 | Commercial | Hull | [NAME] | 30001863 | Overtime | 2009-03-01 00:00:00 | 1
BO-620 | Commercial | Hull | [NAME] | 30001863 | Overtime | 2009-04-01 00:00:00 | 1
BO-620 | Commercial | Hull | [NAME] | 30001863 | Overtime | 2009-05-01 00:00:00 | 1
BO-620 | Commercial | Hull | [NAME] | 30001863 | Overtime | 2009-06-01 00:00:00 | 0.5
BO-620 | Commercial | Hull | [NAME] | 30001863 | Overtime | 2009-07-01 00:00:00 | 2
BO-620 | Commercial | Hull | [NAME] | 30001863 | Overtime | 2009-08-01 00:00:00 | 1
BO-620 | Commercial | Hull | [NAME] | 30001863 | Overtime | 2009-09-01 00:00:00 | 2
BO-620 | Commercial | Hull | [NAME] | 30001863 | Overtime | 2009-10-01 00:00:00 | 1
BO-620 | Commercial | Hull | [NAME] | 30001863 | Overtime | 2009-11-01 00:00:00 | 2
BO-620 | Commercial | Hull | Gawade Prashant Bhaguji | 30002140 | Normal Time | 2008-06-01 00:00:00 | 21
BO-620 | Commercial | Hull | Gawade Prashant Bhaguji | 30002140 | Normal Time | 2008-07-01 00:00:00 | 23
BO-620 | Commercial | Hull | Gawade Prashant Bhaguji | 30002140 | Normal Time | 2008-08-01 00:00:00 | 20
BO-620 | Commercial | Hull | Gawade Prashant Bhaguji | 30002140 | Normal Time | 2008-09-01 00:00:00 | 22
BO-620 | Commercial | Hull | Gawade Prashant Bhaguji | 30002140 | Normal Time | 2008-10-01 00:00:00 | 22
BO-620 | Commercial | Hull | Gawade Prashant Bhaguji | 30002140 | Normal Time | 2008-11-01 00:00:00 | 20
BO-620 | Commercial | Hull | Gawade Prashant Bhaguji | 30002140 | Normal Time | 2008-12-01 00:00:00 | 22
BO-620 | Commercial | Hull | Gawade Prashant Bhaguji | 30002140 | Normal Time | 2009-01-01 00:00:00 | 19
BO-620 | Commercial | Hull | Gawade Prashant Bhaguji | 30002140 | Normal Time | 2009-02-01 00:00:00 | 20
BO-620 | Commercial | Hull | Gawade Prashant Bhaguji | 30002140 | Normal Time | 2009-03-01 00:00:00 | 22
BO-620 | Commercial | Hull | Gawade Prashant Bhaguji | 30002140 | Overtime | 2008-06-01 00:00:00 | 7
BO-620 | Commercial | Hull | Gawade Prashant Bhaguji | 30002140 | Overtime | 2008-07-01 00:00:00 | 5
BO-620 | Commercial | Hull | Gawade Prashant Bhaguji | 30002140 | Overtime | 2008-08-01 00:00:00 | 6
BO-620 | Commercial | Hull | Gawade Prashant Bhaguji | 30002140 | Overtime | 2008-09-01 00:00:00 | 5
BO-620 | Commercial | Hull | Gawade Prashant Bhaguji | 30002140 | Overtime | 2008-10-01 00:00:00 | 9
BO-620 | Commercial | Hull | Gawade Prashant Bhaguji | 30002140 | Overtime | 2008-11-01 00:00:00 | 7
BO-620 | Commercial | Hull | Gawade Prashant Bhaguji | 30002140 | Overtime | 2008-12-01 00:00:00 | 9
BO-620 | Commercial | Hull | Gawade Prashant Bhaguji | 30002140 | Overtime | 2009-01-01 00:00:00 | 3
BO-620 | Commercial | Hull | Gawade Prashant Bhaguji | 30002140 | Overtime | 2009-02-01 00:00:00 | 6
BO-620 | Commercial | Hull | Gawade Prashant Bhaguji | 30002140 | Overtime | 2009-03-01 00:00:00 | 8
BO-620 | Commercial | Hull | [NAME] | 30002470 | Normal Time | 2008-10-01 00:00:00 | 22
BO-620 | Commercial | Hull | [NAME] | 30002470 | Normal Time | 2008-11-01 00:00:00 | 20
BO-620 | Commercial | Hull | [NAME] | 30002470 | Normal Time | 2008-12-01 00:00:00 | 22
BO-620 | Commercial | Hull | [NAME] | 30002470 | Normal Time | 2009-01-01 00:00:00 | 19
BO-620 | Commercial | Hull | [NAME] | 30002470 | Normal Time | 2009-02-01 00:00:00 | 20
BO-620 | Commercial | Hull | [NAME] | 30002470 | Normal Time | 2009-03-01 00:00:00 | 22
BO-620 | Commercial | Hull | [NAME] | 30002470 | Normal Time | 2009-04-01 00:00:00 | 21
BO-620 | Commercial | Hull | [NAME] | 30002470 | Normal Time | 2009-05-01 00:00:00 | 20
BO-620 | Commercial | Hull | [NAME] | 30002470 | Overtime | 2008-10-01 00:00:00 | 4
BO-620 | Commercial | Hull | [NAME] | 30002470 | Overtime | 2008-11-01 00:00:00 | 6
BO-620 | Commercial | Hull | [NAME] | 30002470 | Overtime | 2008-12-01 00:00:00 | 4
BO-620 | Commercial | Hull | [NAME] | 30002470 | Overtime | 2009-01-01 00:00:00 | 4
BO-620 | Commercial | Hull | [NAME] | 30002470 | Overtime | 2009-02-01 00:00:00 | 3
BO-620 | Commercial | Hull | [NAME] | 30002470 | Overtime | 2009-03-01 00:00:00 | 4
BO-620 | Commercial | Hull | [NAME] | 30002470 | Overtime | 2009-04-01 00:00:00 | 2
BO-620 | Commercial | Hull | [NAME] | 30002470 | Overtime | 2009-05-01 00:00:00 | 3