Spreadsheet: 295081d1391592980-help-in-highlighting-a-row-using-conditional-formatting-sample-conditional-formating
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
 | 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 | this is one document what im trying to do is when the status is equal "B" or "UR" yellow highlight will clear.
 | 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 |  | B | but if the status is still "C" it should be highlighted with yellow.
 | HCCR-SD-ME-001 |  |  | 4 | 2nd Basement Level Below Ground Surface Water Layout |  |  | 2013-10-30 00:00:00 | 2013-11-16 00:00:00 |  | B | You will notice that the reference is not changing only the REV column.
 | 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
 | 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 |  | B |  |  |  |  | C | means resubmit
 | 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 |  |  |  |  | B | 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 |  |  |  |  | UR | Under Review
 | 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
 | HCCR/SD/ME/004 |  |  | 0 | Ground Floor Plan Drainage Layout |  |  | 2013-11-17 00:00:00 | 2013-12-07 00:00:00 |  | C
 | HCCR/SD/ME/004 |  |  | 1 | Ground Floor Plan Drainage Layout |  |  | 2013-12-29 00:00:00 | 2014-01-13 00:00:00 |  | C
 | 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
 | HCCR/SD/ME/005 |  |  | 1 | 2nd Basement Plan Overall HVAC Layout |  |  | 2013-12-23 00:00:00 | 2014-01-05 00:00:00 |  | B
 | HCCR/SD/ME/006 |  |  | 0 | 2nd Basement Plan Water Supply Layout |  |  | 2013-11-28 00:00:00 | 2013-12-12 00:00:00 |  | B
 | HCCR/SD/ME/007 |  |  | 0 | 1st Basement Plan Water Supply Layout |  |  | 2013-12-02 00:00:00 | 2013-12-15 00:00:00 |  | C
 | 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
 | 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 | this document should highlight only with yellow because the rest is all approved and under review.
 | HCCR/SD/ME/009 |  |  | 0 | Ground Floor Plan Water Supply Layout |  |  | 2013-12-26 00:00:00 | 2014-01-11 00:00:00 |  | C
 | HCCR/SD/ME/009 |  |  | 1 | Ground Floor Plan Water Supply Layout |  |  | 2014-01-20 00:00:00 | 2014-02-03 00:00:00 |  | B
 | HCCR/SD/ME/010 |  |  | 0 | 1st Basement Plan Overall HVAC Layout |  |  | 2013-12-31 00:00:00 | 2014-01-13 00:00:00 |  | B