Spreadsheet: 295338d1391665901-help-in-highlighting-a-row-using-conditional-formatting-sample-2-
Sheet: MECHANICAL

 | SUBMITTAL REFERENCE |  |  | REV. | [NAME] |  | ORIGINATOR/ SERVICE | DATE SUBMITTED | DATE RETURNED | DAYS HELD | STATUS | REMARKS
 | HCCR-SD-ME-001 |  |  | 0 | 2nd Basement Level Below Ground Surface Water Layout |  |  | 2013-07-29 00:00:00 | 2013-08-19 00:00:00 |  | C | Under Review
 | HCCR-SD-ME-001 |  |  | 1 | 2nd Basement Level Below Ground Surface Water Layout |  |  | 2013-08-26 00:00:00 | 2013-08-31 00:00:00 |  | C
 | HCCR-SD-ME-001 |  |  | 2 | 2nd Basement Level Below Ground Surface Water Layout |  |  | 2013-09-15 00:00:00 | 2013-09-30 00:00:00 |  | C
 | HCCR-SD-ME-001 |  |  | 3 | 2nd Basement Level Below Ground Surface Water Layout |  |  | 2013-10-07 00:00:00 | 2013-10-27 00:00:00 |  | C |  |  |  |  | This is the scenario that im trying to do the latest revision
 | HCCR-SD-ME-001 |  |  | 4 | 2nd Basement Level Below Ground Surface Water Layout |  |  | 2013-10-30 00:00:00 |  |  | UR |  |  |  |  | should be highlighted according to the status it means
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | the old revision will not be highlighted.
 | HCCR-SD-ME-002 |  |  | 0 | 2nd Basement Plan H/L Surface Water Layout |  |  | 2013-09-28 00:00:00 | 2013-10-13 00:00:00 |  | C | Resubmit
 | HCCR-SD-ME-002 |  |  | 1 | 2nd Basement Plan H/L Surface Water Layout |  |  | 2013-10-22 00:00:00 | 2013-11-06 00:00:00 |  | C |  |  |  |  | you will notice that the submittal reference is not changing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | only the revision and the date submitted.
 | HCCR-SD-ME-003 |  |  | 0 | 1st Basement Plan H/L Surface Water Layout |  |  | 2013-11-07 00:00:00 | 2013-11-24 00:00:00 |  | C | Approved
 | HCCR-SD-ME-003 |  |  | 1 | 1st Basement Plan H/L Surface Water Layout |  |  | 2013-11-27 00:00:00 | 2013-12-12 00:00:00 |  | C |  |  |  |  |  |  | Total Records
 | HCCR-SD-ME-003 |  |  | 2 | 1st Basement Plan H/L Surface Water Layout |  |  | 2013-12-17 00:00:00 | 2013-12-31 00:00:00 |  | B |  |  |  |  | Resubmit | C | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Approved | B | 4
 | HCCR/SD/ME/004 |  |  | 0 | Ground Floor Plan Drainage Layout |  |  | 2013-11-17 00:00:00 | 2013-12-07 00:00:00 |  | C | Under Review |  |  |  | Under Review | UR | 3
 | HCCR/SD/ME/004 |  |  | 1 | Ground Floor Plan Drainage Layout |  |  | 2013-12-29 00:00:00 | 2014-01-13 00:00:00 |  | C |  |  |  |  | Total Submitted
 | HCCR/SD/ME/004 |  |  | 2 | Ground Floor Plan Drainage Layout |  |  | 2013-01-22 00:00:00 |  |  | UR
 | HCCR/SD/ME/005 |  |  | 0 | 2nd Basement Plan Overall HVAC Layout |  |  | 2013-11-27 00:00:00 | 2013-12-12 00:00:00 |  | C | Resubmit
 | HCCR/SD/ME/005 |  |  | 1 | 2nd Basement Plan Overall HVAC Layout |  |  | 2013-12-23 00:00:00 | 2014-01-05 00:00:00 |  | C
 | HCCR/SD/ME/006 |  |  | 0 | 2nd Basement Plan Water Supply Layout |  |  | 2013-11-28 00:00:00 | 2013-12-12 00:00:00 |  | B | Approved
 | HCCR/SD/ME/007 |  |  | 0 | 1st Basement Plan Water Supply Layout |  |  | 2013-12-02 00:00:00 | 2013-12-15 00:00:00 |  | C | Approved
 | HCCR/SD/ME/007 |  |  | 1 | 1st Basement Plan Water Supply Layout |  |  | 2013-12-19 00:00:00 | 2013-12-31 00:00:00 |  | B
 | HCCR/SD/ME/008 |  |  | 0 | 2nd Basement Level Fire Fighting Layout |  |  | 2013-12-07 00:00:00 | 2013-12-22 00:00:00 |  | C | Resubmit
 | HCCR/SD/ME/008 |  |  | 1 | 2nd Basement Level Fire Fighting Layout |  |  | 2014-01-04 00:00:00 | 2014-01-18 00:00:00 |  | C
 | HCCR/SD/ME/008 |  |  | 2 | 2nd Basement Level Fire Fighting Layout |  |  | 2014-01-22 00:00:00 | 2014-02-03 00:00:00 |  | C
 | HCCR/SD/ME/009 |  |  | 0 | Ground Floor Plan Water Supply Layout |  |  | 2013-12-26 00:00:00 | 2014-01-11 00:00:00 |  | C | Under Review
 | HCCR/SD/ME/009 |  |  | 1 | Ground Floor Plan Water Supply Layout |  |  | 2014-01-20 00:00:00 |  |  | UR
 | HCCR/SD/ME/010 |  |  | 0 | 1st Basement Plan Overall HVAC Layout |  |  | 2013-12-31 00:00:00 | 2014-01-13 00:00:00 |  | B | Approved