Spreadsheet: 52125d1251828833-can-i-make-a-formula-that-will-highlight-a-cell-highlight-help
Sheet: Sheet1

Equip No | New Equip No | Description | [NAME] TO | Rental Rate | Own | SERIAL NO. | TITLE ON FILE | LIC/SMM  EXPIRED? | LIC/SMM COST | LIC/SMM TAG # | LIC/SMM STATE | LIC/SMM EXPIRES | EMPTY  LBS. | METER TYPE | DOT DUE | LAST  INSP. | LAST  SERVICE | SERVICE  INTERVAL | SERVICE DUE | HR/MI   OVERDUE | Last Major Service | Major Serv. Interval | Major [NAME]. Due | YR BGN HR/MI | PREV. JOB # 2 | HR/MI   AT # 2 | PREV. JOB # 1 | HR/MI   AT # 1 | CURRENT JOB # | DATE ARRIVED | HR/MI ARRIVED | HR/MI    AT JOB | [NAME] | DATE LST. MR | GPS | Year To Date Mi / Hr Total | Purchase Date | Purchase Price | Net Book Value at 3/31/06 | Appraised Value @ Mar '08 | [NAME] vs.Book Value | Comments | Batch Plant Computer [NAME]
50-2-020 | 71-05-002 | [NAME] Batch Plant | JOB | 142.5 | Con | 68243 | NO | NO |  | X214967 | SMM-OFH/CO | 2010-01-01 00:00:00 | 63000 | DT | YES |  | 2002-04-01 00:00:00 | 365 | NO | -37712 |  |  | NO | 0 | 110104 | 0 | 06-09 | 0 | 07-05 | 2007-06-21 00:00:00 | 0 |  | 0 | 2002-09-27 00:00:00 |  |  | 2003-12-03 00:00:00 | 80350.96 | 69636.96 | 1500000 | 1430363.04 |  | 2010-08-26 00:00:00
50-2-061 | 71-05-003 | Con-E-Co LoPro 12 Batch Plant | JOB |  | Con | C6829L |  | NO |  |  |  |  |  | DT | YES |  |  | 365 | NO | -365 |  |  | NO |  |  |  |  |  | 07-05 | 2007-09-26 00:00:00 |  |  |  |  |  |  |  |  |  | 2000000 |  |  | 2011-06-13 00:00:00
50-2-008 | 71-10-001 | R&S Apache [NAME] | JOB | 247.5 | Con | 11827 |  | YES |  |  |  |  |  | DT | YES |  |  | 365 | NO | -365 |  |  | NO |  |  |  | 08-06 | 39738 | 07-05 | 2009-05-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2009-06-30 00:00:00
50-2-010 | 71-15-005 | [NAME] Compumix Batch Plant | JOB | 142.5 | Con | ID31003879CO |  | NO | 18.42 | 421POI | TRL-UT2 | 2010-03-01 00:00:00 | 78705 | DT | YES |  | 2001-08-15 00:00:00 | 365 | NO | -37483 |  |  | NO | 0 | 110404 | 0 | 110501 | 0 | 07-05 | 2007-07-07 00:00:00 | 0 |  | 0 | 2005-02-15 00:00:00 |  |  | 1992-09-02 00:00:00 | 250000 | 0 | 505000 | 505000 |  | 2010-01-05 00:00:00
50-2-005 | 71-20-001 | [NAME] | JOB | 142.5 | Con | S068260B |  | NO | 1200.63 | 121HWF | SMMON2/CO | 2010-07-01 00:00:00 | 56000 | DT | YES |  | 2000-11-20 00:00:00 | 365 | NO | -37215 |  |  | NO | 0 | 08-01 | 0 | 08-02 | 0 | 08-05 | 2008-09-22 00:00:00 | 0 |  | 0 | 2007-09-08 00:00:00 |  |  | 2000-12-15 00:00:00 | 263564 | 149355 | 180000 | 30645 |  | 2009-11-06 00:00:00
50-2-012 | 71-20-002 | [NAME] 12 Batch Plant | JOB | 142.5 | Con | SO68316B |  | NO | 660.63 | 336HMS | SMMON2/CO | 2010-07-01 00:00:00 |  | DT | YES |  |  | 365 | NO | -365 |  |  | NO | 0 | 110406 |  | 60-00 | 0 | 08-05 | 2008-09-25 00:00:00 | 0 |  | 0 | 2008-09-25 00:00:00 |  |  | 2001-09-01 00:00:00 | 152188 | 97654 | 100000 | 2346 |  | 2010-09-27 00:00:00
50-2-009 | 71-30-001 | R&S Apache Ucon Batch Plant 8yd | JOB | 57.5 | Con | 12331 |  | YES |  |  |  |  |  | DT | YES |  |  | 365 | NO | -365 |  |  | NO |  |  |  | 08-06 | 39776 | 08-07 | 2009-06-11 00:00:00 |  |  |  |  |  |  |  | 92160 |  |  |  |  | 2008-01-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | When this date is on or past todays date I would like the description in Column C to Highlight!