Spreadsheet: 82483d1282567013-excel-2007-condtional-formatting-using-date-values-rehab-tc
Sheet: Sheet1

BIN# [NAME]
Unit # | Unit Type | Tenant at Acquisition | TIC | Move-In date | Move-out date | [NAME] | [NAME] | New tenant | TIC | Move-In date | January | February | March | April | May | June | July | August | September | October | November | December
01-0101 | 2a2p | name 1 | X | 2009-12-15 00:00:00 | 2010-02-14 00:00:00 | 2010-02-15 00:00:00 | 2010-05-12 00:00:00 | name 2 | X | 2010-05-13 00:00:00 |  | 2010-02-14 00:00:00 |  |  | 2010-05-13 00:00:00
01-0102 | 2a2p |  |  |  |  | 2009-12-15 00:00:00 | 2010-03-12 00:00:00
01-0103 | 2a2p |  |  |  |  | 2009-12-15 00:00:00 | 2010-03-12 00:00:00
01-0104 | 3a2p |  |  |  |  | 2009-12-15 00:00:00 | 2010-03-12 00:00:00
BIN# MO-09-99002
Unit # | Unit Type | Tenant at Acquisition | TIC | Move-In date | Move-out date | [NAME] | [NAME] | New tenant | TIC | Move-In date | January | February | March | April | May | June | July | August | September | October | November | December
02-0201 | 2a2p |  |  |  |  | 2009-12-15 00:00:00 | 2010-03-12 00:00:00
02-0202 | 2a2p |  |  |  |  | 2009-12-15 00:00:00 | 2010-03-12 00:00:00
02-0203 | 3a2p |  |  |  |  | 2009-12-15 00:00:00 | 2010-03-12 00:00:00
02-0204 | 2a2p |  |  |  |  | 2009-12-15 00:00:00 | 2010-03-12 00:00:00
BIN# MO-09-99003
Unit # | Unit Type | Tenant at Acquisition | TIC | Move-In date | Move-out date | [NAME] | [NAME] | New tenant | TIC | Move-In date | January | February | March | April | May | June | July | August | September | October | November | December
03-0301 | 1ap |  |  |  |  | 2009-12-15 00:00:00 | 2010-04-09 00:00:00
03-0302 | 2a2p |  |  |  |  | 2009-12-15 00:00:00 | 2010-04-09 00:00:00
03-0303 | 3a2p |  |  |  |  | 2009-12-15 00:00:00 | 2010-04-09 00:00:00
03-0304 | 3a2p |  |  |  |  | 2009-12-15 00:00:00 | 2010-04-09 00:00:00
03-0305 | 2a2p |  |  |  |  | 2009-12-15 00:00:00 | 2010-04-09 00:00:00
03-0306 | 3a2p |  |  |  |  | 2009-12-15 00:00:00 | 2010-04-09 00:00:00
03-0307 | 2a2p |  |  |  |  | 2009-12-15 00:00:00 | 2010-04-09 00:00:00
BIN# MO-09-99004
Unit # | Unit Type | Tenant at Acquisition | TIC | Move-In date | Move-out date | [NAME] | [NAME] | New tenant | TIC | Move-In date | January | February | March | April | May | June | July | August | September | October | November | December
04-0401 | 1ap |  |  |  |  | 2009-12-15 00:00:00 | 2010-04-09 00:00:00
04-0402 | 2a2p |  |  |  |  | 2009-12-15 00:00:00 | 2010-04-09 00:00:00
04-0403 | 3a2p |  |  |  |  | 2009-12-15 00:00:00 | 2010-04-09 00:00:00
04-0404 | 1ap |  |  |  |  | 2009-12-15 00:00:00 | 2010-04-09 00:00:00
04-0405 | 1ap |  |  |  |  | 2009-12-15 00:00:00 | 2010-04-09 00:00:00
BIN# MO-09-99005
Unit # | Unit Type | Tenant at Acquisition | TIC | Move-In date | Move-out date | [NAME] | [NAME] | New tenant | TIC | Move-In date | January | February | March | April | May | June | July | August | September | October | November | December
05-0501 | 1ap |  |  |  |  | 2010-04-12 00:00:00 | 2010-06-18 00:00:00
05-0502 | 2a2p |  |  |  |  | 2010-04-12 00:00:00 | 2010-06-18 00:00:00
05-0503 | 3a2p |  |  |  |  | 2010-04-12 00:00:00 | 2010-06-18 00:00:00
05-0504 | 3a2p |  |  |  |  | 2010-04-12 00:00:00 | 2010-06-25 00:00:00
05-0505 | 2a2p |  |  |  |  | 2010-04-12 00:00:00 | 2010-06-25 00:00:00
05-0506 | 3a2p |  |  |  |  | 2010-04-12 00:00:00 | 2010-06-25 00:00:00
05-0507 | 2a2p |  |  |  |  | 2010-04-12 00:00:00 | 2010-06-25 00:00:00
BIN# [NAME]
Unit # | Unit Type | Tenant at Acquisition | TIC | Move-In date | Move-out date | [NAME] | [NAME] | New tenant | TIC | Move-In date | January | February | March | April | May | June | July | August | September | October | November | December
06-0601 | 1ap |  |  |  |  | 2010-04-12 00:00:00 | 2010-06-25 00:00:00
06-0602 | 2a2p |  |  |  |  | 2010-04-12 00:00:00 | 2010-06-25 00:00:00
06-0603 | 3a2p |  |  |  |  | 2010-04-12 00:00:00 | 2010-06-25 00:00:00
06-0604 | 1ap |  |  |  |  | 2010-04-12 00:00:00 | 2010-06-25 00:00:00
06-0605 | 1ap |  |  |  |  | 2010-04-12 00:00:00 | 2010-06-25 00:00:00
BIN# [NAME]
Unit # | Unit Type | Tenant at Acquisition | TIC | Move-In date | Move-out date | [NAME] | [NAME] | New tenant | TIC | Move-In date | January | February | March | April | May | June | July | August | September | October | November | December
07-0701 | 3a2p |  |  |  |  | 2010-03-15 00:00:00 | 2010-05-14 00:00:00
07-0702 | 2a2p |  |  |  |  | 2010-03-15 00:00:00 | 2010-05-14 00:00:00
07-0703 | 3a2p |  |  |  |  | 2010-03-15 00:00:00 | 2010-05-14 00:00:00
07-0704 | 2a2p |  |  |  |  | 2010-03-15 00:00:00 | 2010-05-14 00:00:00
BIN# MO-09-99008
Unit # | Unit Type | Tenant at Acquisition | TIC | Move-In date | Move-out date | [NAME] | [NAME] | New tenant | TIC | Move-In date | January | February | March | April | May | June | July | August | September | October | November | December
08-0801 | 3a2p |  |  |  |  | 2010-06-02 00:00:00 | 2010-08-06 00:00:00
08-0802 | 2a2p |  |  |  |  | 2010-05-17 00:00:00 | 2010-08-06 00:00:00
08-0803 | 3a2p |  |  |  |  | 2010-03-01 00:00:00 | 2010-08-06 00:00:00
08-0804 | 2a2p |  |  |  |  | 2010-06-28 00:00:00 | 2010-08-06 00:00:00
08-0805 | 3a2p |  |  |  |  | 2010-03-01 00:00:00 | 2010-04-30 00:00:00
08-0806 | 2a2p |  |  |  |  | 2010-03-01 00:00:00 | 2010-04-30 00:00:00
08-0807 | 1ap |  |  |  |  | 2010-03-01 00:00:00 | 2010-04-30 00:00:00
BIN# MO-09-99009
Unit # | Unit Type | Tenant at Acquisition | TIC | Move-In date | Move-out date | [NAME] | [NAME] | New tenant | TIC | Move-In date | January | February | March | April | May | June | July | August | September | October | November | December
09-0901 | 2a2p |  |  |  |  | 2010-06-02 00:00:00 | 2010-08-06 00:00:00
09-0902 | 3a2p |  |  |  |  | 2010-06-07 00:00:00 | 2010-08-06 00:00:00
09-0903 | 3a2p |  |  |  |  | 2010-06-15 00:00:00 | 2010-08-06 00:00:00
09-0904 | 2a2p |  |  |  |  | 2010-06-02 00:00:00 | 2010-08-06 00:00:00
09-0905 | 3a2p
09-0906 | 2a2p
09-0907 | 1ap |  |  |  |  | 2010-07-12 00:00:00
BIN# [NAME]
Unit # | Unit Type | Tenant at Acquisition | TIC | Move-In date | Move-out date | [NAME] | [NAME] | New tenant | TIC | Move-In date | January | February | March | April | May | June | July | August | September | October | November | December
10-1001 | 1ap |  |  |  |  | 2010-06-28 00:00:00
10-1002 | 2a2p |  |  |  |  | 2010-06-28 00:00:00
10-1003 | 3a2p |  |  |  |  | 2010-06-28 00:00:00
10-1004 | 1ap |  |  |  |  | 2010-06-28 00:00:00
10-1005 | 1ap |  |  |  |  | 2010-06-28 00:00:00
BIN# [NAME]
Unit # | Unit Type | Tenant at Acquisition | TIC | Move-In date | Move-out date | [NAME] | [NAME] | New tenant | TIC | Move-In date | January | February | March | April | May | June | July | August | September | October | November | December
11-1101 | 2a2p |  |  |  |  | 2010-04-12 00:00:00 | 2010-05-28 00:00:00
11-1102 | 2a2p |  |  |  |  | 2010-04-12 00:00:00 | 2010-05-28 00:00:00
11-1103 | 3a2p |  |  |  |  | 2010-04-12 00:00:00 | 2010-05-28 00:00:00
11-1104 | 2a2p |  |  |  |  | 2010-04-12 00:00:00 | 2010-05-28 00:00:00
BIN# [NAME]
Unit # | Unit Type | Tenant at Acquisition | TIC | Move-In date | Move-out date | [NAME] | [NAME] | New tenant | TIC | Move-In date | January | February | March | April | May | June | July | August | September | October | November | December
12-1201 | 1ap |  |  |  |  | 2010-06-28 00:00:00
12-1202 | 2a2p |  |  |  |  | 2010-06-28 00:00:00
12-1203 | 3a2p |  |  |  |  | 2010-06-28 00:00:00
12-1204 | 2a2p |  |  |  |  | 2010-06-28 00:00:00
12-1205 | 3a2p |  |  |  |  | 2010-06-28 00:00:00
12-1206 | 3a2p |  |  |  |  | 2010-06-28 00:00:00
12-1207 | 2a2p |  |  |  |  | 2010-06-28 00:00:00
BIN# [NAME]
Unit # | Unit Type | Tenant at Acquisition | TIC | Move-In date | Move-out date | [NAME] | [NAME] | New tenant | TIC | Move-In date | January | February | March | April | May | June | July | August | September | October | November | December
13-1301 | 1ap |  |  |  |  | 2010-05-13 00:00:00
13-1302 | 1ap
13-1303 | 1ap |  |  |  |  | 2010-06-02 00:00:00
13-1304 | 1ap
BIN# [NAME]
Unit # | Unit Type | Tenant at Acquisition | TIC | Move-In date | Move-out date | [NAME] | [NAME] | New tenant | TIC | Move-In date | January | February | March | April | May | June | July | August | September | October | November | December
14-1401 | 1ap
14-1402 | 2a2p
14-1403 | 3a2p |  |  |  |  | 2010-07-01 00:00:00
14-1404 | 2a2p
14-1405 | 3a2p
14-1406 | 3a2p
14-1407 | 2a2p |  |  |  |  | 2010-07-01 00:00:00
14-1408 | 2a2p |  |  |  |  | 2010-07-01 00:00:00
14-1409 | 3a2p
14-1410 | 1ap