Spreadsheet: 92801d1292347991-compare-and-highlight-cells-based-on-date-compare-date-sample
Sheet: Sheet3

SOComment | InvoiceDate
JOHNSTON A #13N | 2008-06-24 00:00:00 |  |  |  | I need to compare all the data in column A with all the data in column B on sheet1.
JOHNSTON A #13N | 2008-12-31 00:00:00
JOHNSTON A #13N | 2010-04-14 00:00:00
JOHNSTON A #16 | 2010-06-28 00:00:00 |  |  |  | If they match I need to look at the dates on column B on this sheet(sheet3) and then find all the dates that are listed in 2010 and highlight the correct cell and month on sheet 1.
JOHNSTON A #16 | 2008-08-15 00:00:00
JOHNSTON A #8 | 2007-03-30 00:00:00
JOHNSTON A #8 | 2008-12-31 00:00:00 |  |  |  | Example is the Johnston A #13N.  It matches with sheet 1 and it also has the date of 4-14-10.  So on sheet 1 the correct cell is highlighted.
JOHNSTON A COM C #9 | 2007-03-30 00:00:00 |  |  |  | Same with the Johnston A #16.
JOHNSTON A COM C #9A | 2006-11-30 00:00:00
JOHNSTON A COM C #9A | 2008-07-11 00:00:00
JOHNSTON A COM C #9N | 2008-06-24 00:00:00
JOHNSTON A COM C #9N | 2008-12-31 00:00:00 |  |  |  | I hope my example helps.  Thank you!
JOHNSTON A COM E #12 | 2008-07-11 00:00:00
SJ 27-5 #141 | 2006-09-29 00:00:00
SJ 27-5 #141 | 2007-01-31 00:00:00
SJ 27-5 #141 | 2008-08-28 00:00:00
SJ 27-5 #141 | 2009-02-24 00:00:00
SJ 27-5 #141N | 2006-12-29 00:00:00
SJ 27-5 #141N | 2009-10-30 00:00:00
SJ 27-5 #34A | 2007-01-31 00:00:00
SJ 27-5 #34A | 2009-03-31 00:00:00
SJ 27-5 #34A | 2009-06-09 00:00:00
SJ 27-5 #97M | 2008-07-11 00:00:00
SJ 27-5 #97M | 2009-10-30 00:00:00
SJ 28-6 #11 | 2007-03-30 00:00:00
SJ 28-6 #11 | 2008-06-24 00:00:00
SJ 28-6 #11 | 2009-07-15 00:00:00
SJ 28-6 #110 | 2006-02-20 00:00:00
SJ 28-6 #110 | 2008-07-11 00:00:00
SJ 28-6 #110M | 2008-12-31 00:00:00
SJ 28-6 #111 | 2008-06-30 00:00:00
SJ 28-6 #111 | 2009-06-23 00:00:00
SJ 28-6 #111E | 2007-06-18 00:00:00
SJ 28-6 #111E | 2008-08-31 00:00:00
SJ 28-6 #111M | 2006-05-22 00:00:00
SJ 28-6 #111M | 2008-08-21 00:00:00
SJ 28-6 #111M | 2009-07-01 00:00:00
SJ 28-6 #111P | 2010-01-12 00:00:00
SJ 28-6 #111P | 2010-01-12 00:00:00
SJ 28-6 #111P | 2010-04-22 00:00:00
SJ 28-6 #112 | 2006-12-11 00:00:00
SJ 28-6 #112 | 2008-09-11 00:00:00
SJ 28-6 #112 | 2009-07-01 00:00:00
SJ 28-6 #11A | 2006-12-11 00:00:00
SJ 28-6 #11A | 2008-09-11 00:00:00
SJ 28-6 #11A | 2009-07-01 00:00:00
SJ 28-6 #146 | 2006-10-17 00:00:00
SJ 28-6 #146M | 2008-06-30 00:00:00
SJ 28-6 #146N | 2008-08-21 00:00:00
SJ 28-6 #146N | 2006-07-13 00:00:00
SJ 28-6 #146N | 2009-10-30 00:00:00
SJ 28-6 #157 | 2006-08-16 00:00:00
SJ 28-6 #157 | 2008-07-11 00:00:00
SJ 28-6 #157 | 2006-07-13 00:00:00
SJ 28-6 #157 | 2009-10-30 00:00:00
SJ 28-6 #157M | 2008-08-31 00:00:00
SJ 28-6 #168 | 2008-08-21 00:00:00
SJ 28-6 #168 | 2009-07-01 00:00:00
SJ 28-6 #168E | 2007-06-18 00:00:00
SJ 28-6 #168E | 2007-06-18 00:00:00
SJ 28-6 #168E | 2008-08-25 00:00:00
SJ 28-6 #168E | 2009-07-01 00:00:00
SJ 28-6 #168M | 2008-05-29 00:00:00
SJ 28-6 #168M | 2008-10-31 00:00:00
SJ 28-6 #170N | 2008-06-24 00:00:00
SJ 28-6 #170N | 2009-07-01 00:00:00
SJ 28-6 #170N | 2006-04-28 00:00:00
SJ 28-6 #171 | 2008-08-21 00:00:00
SJ 28-6 #171M | 2006-11-30 00:00:00
SJ 28-6 #171M | 2008-07-11 00:00:00
SJ 28-6 #179 | 2008-08-15 00:00:00
SJ 28-6 #179 | 2009-07-01 00:00:00
SJ 28-6 #179 | 2010-04-14 00:00:00
SJ 28-6 #179N | 2009-10-20 00:00:00
SJ 28-6 #179N | 2009-10-20 00:00:00
SJ 28-6 #181 | 2010-05-28 00:00:00
SJ 28-6 #181 | 2006-06-21 00:00:00
SJ 28-6 #181M | 2006-12-29 00:00:00
SJ 28-6 #181M | 2008-08-15 00:00:00
SJ 28-6 #181M | 2009-07-01 00:00:00
SJ 28-6 #181M | 2006-01-27 00:00:00
SJ 28-6 #181N | 2009-12-18 00:00:00
SJ 28-6 #181N | 2009-12-18 00:00:00
SJ 28-6 #181N | 2010-03-09 00:00:00
SJ 28-6 #183N | 2009-03-23 00:00:00
SJ 28-6 #183N | 2009-03-23 00:00:00
SJ 28-6 #183N | 2009-05-18 00:00:00
SJ 28-6 #204 | 2010-06-28 00:00:00
SJ 28-6 #204 | 2006-12-29 00:00:00
SJ 28-6 #204 | 2009-03-18 00:00:00
SJ 28-6 #204M | 2006-08-31 00:00:00
SJ 28-6 #204M | 2008-06-30 00:00:00
SJ 28-6 #204M | 2009-07-01 00:00:00
SJ 28-6 #204N | 2010-06-24 00:00:00
SJ 28-6 #204N | 2009-05-26 00:00:00
SJ 28-6 #204N | 2009-05-26 00:00:00
SJ 28-6 #205 | 2007-03-30 00:00:00
SJ 28-6 #205 | 2007-03-30 00:00:00
SJ 28-6 #205 | 2009-06-16 00:00:00
SJ 28-6 #205 | 2009-07-30 00:00:00
SJ 28-6 #205 | 2009-07-30 00:00:00
SJ 28-6 #205 | 2010-04-07 00:00:00
SJ 28-6 #205M | 2006-12-15 00:00:00
SJ 28-6 #205M | 2008-09-11 00:00:00
SJ 28-6 #205M | 2009-07-01 00:00:00
SJ 28-6 #205M | 2006-01-27 00:00:00
SJ 28-6 #206M | 2006-10-17 00:00:00
SJ 28-6 #206M | 2009-03-18 00:00:00
SJ 28-6 #207 | 2006-12-11 00:00:00
SJ 28-6 #207 | 2008-08-21 00:00:00
SJ 28-6 #207 | 2009-07-01 00:00:00
SJ 28-6 #207N | 2007-03-30 00:00:00
SJ 28-6 #207N | 2009-06-23 00:00:00
SJ 28-6 #207P | 2009-08-20 00:00:00
SJ 28-6 #207P | 2009-08-20 00:00:00
SJ 28-6 #209 | 2009-07-01 00:00:00
SJ 28-6 #209 | 2010-06-17 00:00:00
SJ 28-6 #209M | 2008-08-25 00:00:00
SJ 28-6 #209M | 2008-09-25 00:00:00
SJ 28-6 #209M | 2010-04-08 00:00:00
SJ 28-6 #22 | 2010-06-24 00:00:00
SJ 28-6 #22 | 2007-03-30 00:00:00
SJ 28-6 #22 | 2008-07-11 00:00:00
SJ 28-6 #22 | 2009-07-01 00:00:00
SJ 28-6 #22A | 2007-03-30 00:00:00
SJ 28-6 #22A | 2009-08-05 00:00:00
SJ 28-6 #23 | 2006-11-30 00:00:00
SJ 28-6 #23 | 2009-07-01 00:00:00
SJ 28-6 #25 | 2006-11-16 00:00:00
SJ 28-6 #25 | 2009-07-01 00:00:00
SJ 28-6 #27 | 2006-12-15 00:00:00
SJ 28-6 #27 | 2008-06-24 00:00:00
SJ 28-6 #27 | 2009-07-01 00:00:00
SJ 28-6 #27A | 2010-06-24 00:00:00
SJ 28-6 #27A | 2006-12-15 00:00:00
SJ 28-6 #27A | 2008-09-11 00:00:00
SJ 28-6 #27A | 2009-07-01 00:00:00
SJ 28-6 #6 | 2006-11-16 00:00:00
SJ 28-6 #6 | 2009-07-01 00:00:00
SJ 28-6 #64 | 2008-08-25 00:00:00
SJ 28-6 #64 | 2009-07-01 00:00:00
SJ 28-6 #67A | 2008-09-11 00:00:00
SJ 28-6 #67A | 2009-07-01 00:00:00
SJ 28-6 #68 | 2008-06-30 00:00:00
SJ 28-6 #68 | 2008-09-11 00:00:00
SJ 28-6 #68 | 2009-07-01 00:00:00
SJ 28-6 #69 | 2008-06-24 00:00:00
SJ 28-6 #69 | 2008-07-31 00:00:00
SJ 28-6 #69 | 2008-12-31 00:00:00
SJ 28-6 #69 | 2009-05-12 00:00:00
SJ 28-6 #69A | 2006-11-30 00:00:00
SJ 28-6 #69A | 2006-11-30 00:00:00
SJ 28-6 #6A | 2009-07-01 00:00:00
SJ 28-6 #70 | 2008-08-15 00:00:00
SJ 28-6 #79 | 2006-12-29 00:00:00
SJ 28-6 #79 | 2008-09-11 00:00:00
SJ 28-6 #79 | 2009-07-01 00:00:00
SJ 28-6 #79 | 2009-10-14 00:00:00
SJ 28-6 #85 | 2010-06-28 00:00:00
SJ 28-6 #85 | 2009-02-23 00:00:00
SJ 28-6 #86 | 2008-06-30 00:00:00
SJ 28-6 #86 | 2008-08-28 00:00:00
SJ 28-6 #86 | 2009-07-01 00:00:00
SJ 28-6 NP #422 | 2009-01-30 00:00:00