Spreadsheet: 100896d1299105353-excel-2007-conditional-formatting-multiple-conditions-demo-customer-leads-template
Sheet: Agent 6

Lead Id | Lead Type Id | First Name | Last Name | Address | City | State | Zip | [NAME] | Phone | Inquiry Type Id | DateTimeCreated | DateTimeUpdated | Inquiry Type Name
210437 | 2 | Customer | Last Name | 148 main st | spring grove | IL | 60081 |  |  | 5 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Home Office (home business)
210470 | 2 | Customer | Last Name | 149 main st | [NAME] | IN | 47108 |  |  | 4 | 2011-02-17 00:00:00 | 2011-02-17 00:00:00 | Residential
210478 | 2 | Customer | Last Name | 150 main st | [NAME] | IN | 47404 |  |  | 6 | 2011-02-22 00:00:00 | 2011-02-22 00:00:00 | Small Office
210556 | 2 | Customer | Last Name | 151 main st | WASHINGTON | IN | 47501 |  |  | 4 | 2011-02-25 00:00:00 | 2011-02-25 00:00:00 | Residential
210610 | 2 | Customer | Last Name | 152 main st | Brookville | IN | 47012 |  |  | 4 | 2011-02-27 00:00:00 | 2011-02-27 00:00:00 | Residential
210626 | 2 | Customer | Last Name | 153 main st | Hudson | IN | 46747 |  |  | 4 | 2011-02-28 00:00:00 | 2011-02-28 00:00:00 | Residential
210453 | 2 | Customer | Last Name | 154 main st | Henderson | KY | 42420 |  |  | 7 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Work from Home (telecommuter)
210443 | 2 | Customer | Last Name | 155 main st | Salvisa | KY | 40372 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210431 | 2 | Customer | Last Name | 156 main st | Salyersville | KY | 41465 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210465 | 2 | Customer | Last Name | 157 main st | [NAME] | KY | 40336 |  |  | 4 | 2011-02-17 00:00:00 | 2011-02-17 00:00:00 | Residential
210487 | 2 | Customer | Last Name | 158 main st | Williamsburg | KY | 40769 |  |  | 4 | 2011-02-22 00:00:00 | 2011-02-22 00:00:00 | Residential
210525 | 2 | Customer | Last Name | 159 main st | Owenton | KY | 40359 |  |  | 4 | 2011-02-23 00:00:00 | 2011-02-23 00:00:00 | Residential
210504 | 2 | Customer | Last Name | 160 main st | [NAME] | KY | 42544 |  |  | 4 | 2011-02-23 00:00:00 | 2011-02-23 00:00:00 | Residential
210565 | 2 | Customer | Last Name | 161 main st | Frankfort | KY | 40601 |  |  | 4 | 2011-02-25 00:00:00 | 2011-02-25 00:00:00 | Residential
210634 | 2 | Customer | Last Name | 162 main st | beattyville | KY | 41311 |  |  | 4 | 2011-02-28 00:00:00 | 2011-02-28 00:00:00 | Residential
210477 | 2 | Customer | Last Name | 174 main st | Amherst | MA | 1002 |  |  | 4 | 2011-02-22 00:00:00 | 2011-02-22 00:00:00 | Residential
210538 | 2 | Customer | Last Name | 175 main st | [NAME] | MD | 21672 |  |  | 4 | 2011-02-24 00:00:00 | 2011-02-24 00:00:00 | Residential
210480 | 2 | Customer | Last Name | 176 main st | Edwardsburg | MI | 49112 |  |  | 6 | 2011-02-22 00:00:00 | 2011-02-22 00:00:00 | Small Office
210536 | 2 | Customer | Last Name | 177 main st | grass lake | MI | 49240 |  |  | 4 | 2011-02-24 00:00:00 | 2011-02-24 00:00:00 | Residential
210564 | 2 | Customer | Last Name | 178 main st | VICKSBURG | MI | 49097 |  |  | 4 | 2011-02-25 00:00:00 | 2011-02-25 00:00:00 | Residential
210458 | 2 | Customer | Last Name | 184 main st | laurel | MS | 39443 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210439 | 2 | Customer | Last Name | 185 main st | Pope | MS | 38658 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210467 | 2 | Customer | Last Name | 186 main st | Sumrall | MS | 39482 |  |  | 4 | 2011-02-17 00:00:00 | 2011-02-17 00:00:00 | Residential
210548 | 2 | Customer | Last Name | 187 main st | West Point | MS | 39773 |  |  | 4 | 2011-02-24 00:00:00 | 2011-02-24 00:00:00 | Residential
210425 | 2 | Customer | Last Name | 190 main st | ROCKY POINT | NC | 28457 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210475 | 2 | Customer | Last Name | 191 main st | scotland neck | NC | 27874 |  |  | 4 | 2011-02-22 00:00:00 | 2011-02-22 00:00:00 | Residential
210523 | 2 | Customer | Last Name | 192 main st | Hollyridge | NC | 28445 |  |  | 4 | 2011-02-23 00:00:00 | 2011-02-23 00:00:00 | Residential
210512 | 2 | Customer | Last Name | 193 main st | Newton | NC | 28658 |  |  | 4 | 2011-02-23 00:00:00 | 2011-02-23 00:00:00 | Residential
210533 | 2 | Customer | Last Name | 194 main st | South Mills | NC | 27976 |  |  | 4 | 2011-02-24 00:00:00 | 2011-02-24 00:00:00 | Residential
210584 | 2 | Customer | Last Name | 195 main st | washington | NC | 27889 |  |  | 4 | 2011-02-26 00:00:00 | 2011-02-26 00:00:00 | Residential
210614 | 2 | Customer | Last Name | 196 main st | Weaverville | NC | 28787 |  |  | 4 | 2011-02-27 00:00:00 | 2011-02-27 00:00:00 | Residential
210613 | 2 | Customer | Last Name | 197 main st | [NAME] | NC | 28358 |  |  | 4 | 2011-02-27 00:00:00 | 2011-02-27 00:00:00 | Residential
210469 | 2 | Customer | Last Name | 199 main st | LODI | NJ | 7644 |  |  | 4 | 2011-02-17 00:00:00 | 2011-02-17 00:00:00 | Residential
210450 | 2 | Customer | Last Name | 200 main st | belpre | OH | 45714 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210448 | 2 | Customer | Last Name | 201 main st | WESTERVILLE | OH | 43081-9526 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210441 | 2 | Customer | Last Name | 202 main st | Farmersville | OH | 45325 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210440 | 2 | Customer | Last Name | 203 main st | Middletown | OH | 45042 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210430 | 2 | Customer | Last Name | 204 main st | Racine | OH | 45771 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210429 | 2 | Customer | Last Name | 205 main st | Reynoldsburg | OH | 43068 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210494 | 2 | Customer | Last Name | 206 main st | Pleasantville | OH | 43148 |  |  | 4 | 2011-02-22 00:00:00 | 2011-02-22 00:00:00 | Residential
210488 | 2 | Customer | Last Name | 207 main st | Piketon | OH | 45661 |  |  | 4 | 2011-02-22 00:00:00 | 2011-02-22 00:00:00 | Residential
210521 | 2 | Customer | Last Name | 208 main st | Uhrichsville | OH | 44683 |  |  | 4 | 2011-02-23 00:00:00 | 2011-02-23 00:00:00 | Residential
210516 | 2 | Customer | Last Name | 209 main st | Syracuse | OH | 45779 |  |  | 4 | 2011-02-23 00:00:00 | 2011-02-23 00:00:00 | Residential
210498 | 2 | Customer | Last Name | 210 main st | SULLIVAN | OH | 44880 |  |  | 4 | 2011-02-23 00:00:00 | 2011-02-23 00:00:00 | Residential
210537 | 2 | Customer | Last Name | 211 main st | CENTERVILLE | OH | 45459 |  |  | 4 | 2011-02-24 00:00:00 | 2011-02-24 00:00:00 | Residential
210534 | 2 | Customer | Last Name | 212 main st | Laurelville | OH | 43135 |  |  | 4 | 2011-02-24 00:00:00 | 2011-02-24 00:00:00 | Residential
210567 | 2 | Customer | Last Name | 213 main st | mount orab | OH | 45154 |  |  | 4 | 2011-02-25 00:00:00 | 2011-02-25 00:00:00 | Residential
210561 | 2 | Customer | Last Name | 214 main st | middleport | OH | 45760 |  |  | 4 | 2011-02-25 00:00:00 | 2011-02-25 00:00:00 | Residential
210553 | 2 | Customer | Last Name | 215 main st | lancaster | OH | 43130 |  |  | 4 | 2011-02-25 00:00:00 | 2011-02-25 00:00:00 | Residential
210591 | 2 | Customer | Last Name | 216 main st | Gallipolis | OH | 45631 |  |  | 4 | 2011-02-26 00:00:00 | 2011-02-26 00:00:00 | Residential
210590 | 2 | Customer | Last Name | 217 main st | SALESVILLE | OH | 43778 |  |  | 4 | 2011-02-26 00:00:00 | 2011-02-26 00:00:00 | Residential
210578 | 2 | Customer | Last Name | 218 main st | South Point | OH | 45680 |  |  | 4 | 2011-02-26 00:00:00 | 2011-02-26 00:00:00 | Residential
210618 | 2 | Customer | Last Name | 219 main st | Mt. Orab | OH | 45154 |  |  | 4 | 2011-02-27 00:00:00 | 2011-02-27 00:00:00 | Residential
210607 | 2 | Customer | Last Name | 220 main st | Chandlersville | OH | 43727 |  |  | 4 | 2011-02-27 00:00:00 | 2011-02-27 00:00:00 | Residential
210604 | 2 | Customer | Last Name | 221 main st | Middleport | OH | 45760 |  |  | 4 | 2011-02-27 00:00:00 | 2011-02-27 00:00:00 | Residential
210631 | 2 | Customer | Last Name | 222 main st | COLUMBUS | OH | 43211 |  |  | 4 | 2011-02-28 00:00:00 | 2011-02-28 00:00:00 | Residential
210461 | 2 | Customer | Last Name | 232 main st | [NAME] | SC | 29555 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210460 | 2 | Customer | Last Name | 233 main st | [NAME] | SC | 29555 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210486 | 2 | Customer | Last Name | 234 main st | bonneau | SC | 29479 |  |  | 4 | 2011-02-22 00:00:00 | 2011-02-22 00:00:00 | Residential
210482 | 2 | Customer | Last Name | 235 main st | [NAME] | SC | 29471 |  |  | 4 | 2011-02-22 00:00:00 | 2011-02-22 00:00:00 | Residential
210524 | 2 | Customer | Last Name | 236 main st | [NAME] | SC | 29340 |  |  | 4 | 2011-02-23 00:00:00 | 2011-02-23 00:00:00 | Residential
210513 | 2 | Customer | Last Name | 237 main st | Honea Path | SC | 29654 |  |  | 4 | 2011-02-23 00:00:00 | 2011-02-23 00:00:00 | Residential
210505 | 2 | Customer | Last Name | 238 main st | Ridgeway | SC | 29130 |  |  | 4 | 2011-02-23 00:00:00 | 2011-02-23 00:00:00 | Residential
210503 | 2 | Customer | Last Name | 239 main st | Rock Hill | SC | 29730 |  |  | 4 | 2011-02-23 00:00:00 | 2011-02-23 00:00:00 | Residential
210499 | 2 | Customer | Last Name | 240 main st | Blythewood | SC | 29016 |  |  | 4 | 2011-02-23 00:00:00 | 2011-02-23 00:00:00 | Residential
210539 | 2 | Customer | Last Name | 241 main st | Saint George | SC | 29477 |  |  | 4 | 2011-02-24 00:00:00 | 2011-02-24 00:00:00 | Residential
210558 | 2 | Customer | Last Name | 242 main st | Barnwell | SC | 29812 |  |  | 4 | 2011-02-25 00:00:00 | 2011-02-25 00:00:00 | Residential
210557 | 2 | Customer | Last Name | 243 main st | Barnwell | SC | 29812 |  |  | 4 | 2011-02-25 00:00:00 | 2011-02-25 00:00:00 | Residential
210615 | 2 | Customer | Last Name | 244 main st | florence | SC | 29501 |  |  | 4 | 2011-02-27 00:00:00 | 2011-02-27 00:00:00 | Residential
210622 | 2 | Customer | Last Name | 245 main st | Barnwell | SC | 29812 |  |  | 4 | 2011-02-28 00:00:00 | 2011-02-28 00:00:00 | Residential
210455 | 2 | Customer | Last Name | 248 main st | woodlawn | TN | 37191 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210454 | 2 | Customer | Last Name | 249 main st | [NAME] | TN | 37863 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210452 | 2 | Customer | Last Name | 250 main st | cookeville | TN | 38506 |  |  | 5 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Home Office (home business)
210435 | 2 | Customer | Last Name | 251 main st | lebanon | TN | 37087 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210464 | 2 | Customer | Last Name | 252 main st | charleston | TN | 37310 |  |  | 4 | 2011-02-17 00:00:00 | 2011-02-17 00:00:00 | Residential
210490 | 2 | Customer | Last Name | 253 main st | Del Rio | TN | 37727 |  |  | 4 | 2011-02-22 00:00:00 | 2011-02-22 00:00:00 | Residential
210485 | 2 | Customer | Last Name | 254 main st | Andersonville | TN | 37705-3108 |  |  | 4 | 2011-02-22 00:00:00 | 2011-02-22 00:00:00 | Residential
210528 | 2 | Customer | Last Name | 255 main st | [NAME] | TN | 37881 |  |  | 4 | 2011-02-23 00:00:00 | 2011-02-23 00:00:00 | Residential
210532 | 2 | Customer | Last Name | 256 main st | Belfast | TN | 37019 |  |  | 4 | 2011-02-24 00:00:00 | 2011-02-24 00:00:00 | Residential
210576 | 2 | Customer | Last Name | 257 main st | [NAME] | TN | 37774 |  |  | 4 | 2011-02-25 00:00:00 | 2011-02-25 00:00:00 | Residential
210575 | 2 | Customer | Last Name | 258 main st | seymour | TN | 37865 |  |  | 4 | 2011-02-25 00:00:00 | 2011-02-25 00:00:00 | Residential
210573 | 2 | Customer | Last Name | 259 main st | Turtletown | TN | 37391 |  |  | 4 | 2011-02-25 00:00:00 | 2011-02-25 00:00:00 | Residential
210581 | 2 | Customer | Last Name | 260 main st | Knoxville | TN | 37920 |  |  | 4 | 2011-02-26 00:00:00 | 2011-02-26 00:00:00 | Residential
210612 | 2 | Customer | Last Name | 261 main st | Sweetwater | TN | 37874 |  |  | 4 | 2011-02-27 00:00:00 | 2011-02-27 00:00:00 | Residential
210444 | 2 | Customer | Last Name | 290 main st | va. | VA | 23944 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210427 | 2 | Customer | Last Name | 291 main st | COVINGTON | VA | 24426 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210426 | 2 | Customer | Last Name | 292 main st | Aylett | VA | 23009 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210423 | 2 | Customer | Last Name | 293 main st | Cleveland | VA | 24225 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210466 | 2 | Customer | Last Name | 294 main st | swords creek | VA | 24649 |  |  | 4 | 2011-02-17 00:00:00 | 2011-02-17 00:00:00 | Residential
210484 | 2 | Customer | Last Name | 295 main st | Smithfield | VA | 23430 |  |  | 4 | 2011-02-22 00:00:00 | 2011-02-22 00:00:00 | Residential
210474 | 2 | Customer | Last Name | 296 main st | Culpeper | VA | 22701 |  |  | 4 | 2011-02-22 00:00:00 | 2011-02-22 00:00:00 | Residential
210529 | 2 | Customer | Last Name | 297 main st | REEDVILLE | VA | 22539 |  |  | 6 | 2011-02-23 00:00:00 | 2011-02-23 00:00:00 | Small Office
210517 | 2 | Customer | Last Name | 298 main st | Emporia | VA | 23847 |  |  | 4 | 2011-02-23 00:00:00 | 2011-02-23 00:00:00 | Residential
210506 | 2 | Customer | Last Name | 299 main st | Spotsylvania | VA | 22553 |  |  | 4 | 2011-02-23 00:00:00 | 2011-02-23 00:00:00 | Residential
210544 | 2 | Customer | Last Name | 300 main st | Drewryville | VA | 23844 |  |  | 4 | 2011-02-24 00:00:00 | 2011-02-24 00:00:00 | Residential
210571 | 2 | Customer | Last Name | 301 main st | [NAME] | VA | 24237 |  |  | 4 | 2011-02-25 00:00:00 | 2011-02-25 00:00:00 | Residential
210569 | 2 | Customer | Last Name | 302 main st | spotslyvania | VA | 22551 |  |  | 4 | 2011-02-25 00:00:00 | 2011-02-25 00:00:00 | Residential
210596 | 2 | Customer | Last Name | 303 main st | Culpeper | VA | 22701 |  |  | 4 | 2011-02-26 00:00:00 | 2011-02-26 00:00:00 | Residential
210616 | 2 | Customer | Last Name | 304 main st | SPOTSYLVANIA | VA | 22551 |  |  | 4 | 2011-02-27 00:00:00 | 2011-02-27 00:00:00 | Residential
210603 | 2 | Customer | Last Name | 305 main st | pearisburg | VA | 24134 |  |  | 4 | 2011-02-27 00:00:00 | 2011-02-27 00:00:00 | Residential
210602 | 2 | Customer | Last Name | 306 main st | [NAME] | VA | 20119 |  |  | 4 | 2011-02-27 00:00:00 | 2011-02-27 00:00:00 | Residential
210620 | 2 | Customer | Last Name | 307 main st | RHOADESVILLE | VA | 22542 |  |  | 4 | 2011-02-28 00:00:00 | 2011-02-28 00:00:00 | Residential
210481 | 2 | Customer | Last Name | 308 main st | Vershire | VT | 5079 |  |  | 5 | 2011-02-22 00:00:00 | 2011-02-22 00:00:00 | Home Office (home business)
210462 | 2 | Customer | Last Name | 311 main st | Ellsworth | WI | 54011 |  |  | 4 | 2011-02-17 00:00:00 | 2011-02-17 00:00:00 | Residential
210436 | 2 | Customer | Last Name | 312 main st | [NAME] | WV | 26434 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210531 | 2 | Customer | Last Name | 313 main st | [NAME] | WV | 26624 |  |  | 4 | 2011-02-24 00:00:00 | 2011-02-24 00:00:00 | Residential
210568 | 2 | Customer | Last Name | 314 main st | kerens | WV | 26276 |  |  | 4 | 2011-02-25 00:00:00 | 2011-02-25 00:00:00 | Residential
210562 | 2 | Customer | Last Name | 315 main st | layland | WV | 25864 |  |  | 5 | 2011-02-25 00:00:00 | 2011-02-25 00:00:00 | Home Office (home business)
210559 | 2 | Customer | Last Name | 316 main st | POINT PLEASANT | WV | 25550 |  |  | 4 | 2011-02-25 00:00:00 | 2011-02-25 00:00:00 | Residential
210551 | 2 | Customer | Last Name | 317 main st | Franklin | WV | 26807 |  |  | 4 | 2011-02-25 00:00:00 | 2011-02-25 00:00:00 | Residential
210587 | 2 | Customer | Last Name | 318 main st | princeton | WV | 24740 |  |  | 4 | 2011-02-26 00:00:00 | 2011-02-26 00:00:00 | Residential
210579 | 2 | Customer | Last Name | 319 main st | Daniels | WV | 25832 |  |  | 4 | 2011-02-26 00:00:00 | 2011-02-26 00:00:00 | Residential
210617 | 2 | Customer | Last Name | 320 main st | SOUTHSIDE | WV | 25187 |  |  | 4 | 2011-02-27 00:00:00 | 2011-02-27 00:00:00 | Residential