Find

ITSDISP

New Member
Joined
Oct 8, 2010
Messages
16
I have two columns, I want to search for the cities in the 2nd column and highlight those cities in the 1st column. [TABLE="width: 284"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ARBYRD MO[/TD]
[TD]ARBYRD MO[/TD]
[/TR]
[TR]
[TD]ARBYRD MO[/TD]
[TD]HORNERSVILLE MO[/TD]
[/TR]
[TR]
[TD]ARBYRD MO[/TD]
[TD]COOTER MO[/TD]
[/TR]
[TR]
[TD]ARBYRD MO[/TD]
[TD]HOLLAND MO[/TD]
[/TR]
[TR]
[TD]ARBYRD MO[/TD]
[TD]CARDWELL MO[/TD]
[/TR]
[TR]
[TD]AVA MO[/TD]
[TD]RIVES MO[/TD]
[/TR]
[TR]
[TD]AVA MO[/TD]
[TD]STEELE MO[/TD]
[/TR]
[TR]
[TD]AVA MO[/TD]
[TD]GOBLER MO[/TD]
[/TR]
[TR]
[TD]AVA MO[/TD]
[TD]SENATH MO[/TD]
[/TR]
[TR]
[TD]AVA MO[/TD]
[TD]CARUTHERSVILLE MO[/TD]
[/TR]
[TR]
[TD]BALLWIN MO[/TD]
[TD]BRAGGADOCIO MO[/TD]
[/TR]
[TR]
[TD]BALLWIN MO[/TD]
[TD]DEERING MO[/TD]
[/TR]
[TR]
[TD]BALLWIN MO[/TD]
[TD]KENNETT MO[/TD]
[/TR]
[TR]
[TD]BALLWIN MO[/TD]
[TD]BRAGG CITY MO[/TD]
[/TR]
[TR]
[TD]BALLWIN MO[/TD]
[TD]HAYTI MO[/TD]
[/TR]
[TR]
[TD]BERNIE MO[/TD]
[TD]WHITEOAK MO[/TD]
[/TR]
[TR]
[TD]BERNIE MO[/TD]
[TD]WARDELL MO[/TD]
[/TR]
[TR]
[TD]BERNIE MO[/TD]
[TD]HOLCOMB MO[/TD]
[/TR]
[TR]
[TD]BERNIE MO[/TD]
[TD]CLARKTON MO[/TD]
[/TR]
[TR]
[TD]BERNIE MO[/TD]
[TD]GIBSON MO[/TD]
[/TR]
[TR]
[TD]BIRCH TREE MO[/TD]
[TD]PORTAGEVILLE MO[/TD]
[/TR]
[TR]
[TD]BIRCH TREE MO[/TD]
[TD]GIDEON MO[/TD]
[/TR]
[TR]
[TD]BIRCH TREE MO[/TD]
[TD]CAMPBELL MO[/TD]
[/TR]
[TR]
[TD]BIRCH TREE MO[/TD]
[TD]TALLAPOOSA MO[/TD]
[/TR]
[TR]
[TD]BIRCH TREE MO[/TD]
[TD]RISCO MO[/TD]
[/TR]
[TR]
[TD]BISMARCK MO[/TD]
[TD]MALDEN MO[/TD]
[/TR]
[TR]
[TD]BISMARCK MO[/TD]
[TD]MARSTON MO[/TD]
[/TR]
[TR]
[TD]BISMARCK MO[/TD]
[TD]QULIN MO[/TD]
[/TR]
[TR]
[TD]BISMARCK MO[/TD]
[TD]NEELYVILLE MO[/TD]
[/TR]
[TR]
[TD]BISMARCK MO[/TD]
[TD]LILBOURN MO[/TD]
[/TR]
[TR]
[TD]BLOOMFIELD MO[/TD]
[TD]PARMA MO[/TD]
[/TR]
[TR]
[TD]BLOOMFIELD MO[/TD]
[TD]NAYLOR MO[/TD]
[/TR]
[TR]
[TD]BLOOMFIELD MO[/TD]
[TD]NEW MADRID MO[/TD]
[/TR]
[TR]
[TD]BLOOMFIELD MO[/TD]
[TD]CATRON MO[/TD]
[/TR]
[TR]
[TD]BLOOMFIELD MO[/TD]
[TD]OXLY MO[/TD]
[/TR]
[TR]
[TD]BLOOMSDALE MO[/TD]
[TD]BERNIE MO[/TD]
[/TR]
[TR]
[TD]BLOOMSDALE MO[/TD]
[TD]BROSELEY MO[/TD]
[/TR]
[TR]
[TD]BLOOMSDALE MO[/TD]
[TD]KEWANEE MO[/TD]
[/TR]
[TR]
[TD]BLOOMSDALE MO[/TD]
[TD]HARVIELL MO[/TD]
[/TR]
[TR]
[TD]BLOOMSDALE MO[/TD]
[TD]FAIRDEALING MO[/TD]
[/TR]
[TR]
[TD]BRANDSVILLE MO[/TD]
[TD]CANALOU MO[/TD]
[/TR]
[TR]
[TD]BRANDSVILLE MO[/TD]
[TD]DEXTER MO[/TD]
[/TR]
[TR]
[TD]BRANDSVILLE MO[/TD]
[TD]POPLAR BLUFF MO[/TD]
[/TR]
[TR]
[TD]BRANDSVILLE MO[/TD]
[TD]GATEWOOD MO[/TD]
[/TR]
[TR]
[TD]BRANDSVILLE MO[/TD]
[TD]FISK MO[/TD]
[/TR]
[TR]
[TD]BRANSON MO[/TD]
[TD]DUDLEY MO[/TD]
[/TR]
[TR]
[TD]BRANSON MO[/TD]
[TD]DONIPHAN MO[/TD]
[/TR]
[TR]
[TD]BRANSON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BRANSON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BRANSON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CABOOL MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CABOOL MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CABOOL MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CABOOL MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CABOOL MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CAMPBELL MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CAMPBELL MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CAMPBELL MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CAMPBELL MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CAMPBELL MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CAPE GIRARDEAU MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CAPE GIRARDEAU MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CAPE GIRARDEAU MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CAPE GIRARDEAU MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CAPE GIRARDEAU MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CARDWELL MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CARDWELL MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CARDWELL MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CARDWELL MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CARDWELL MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CARTHAGE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CARTHAGE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CARTHAGE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CARTHAGE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CARTHAGE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CARUTHERSVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CARUTHERSVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CARUTHERSVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CARUTHERSVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CARUTHERSVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CHARLESTON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CHARLESTON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CHARLESTON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CHARLESTON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CHARLESTON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CLARKTON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CLARKTON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CLARKTON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CLARKTON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CLARKTON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]COLUMBIA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]COLUMBIA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]COLUMBIA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]COLUMBIA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]COLUMBIA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]COOTER MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]COOTER MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]COOTER MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]COOTER MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]COOTER MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DEXTER MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DEXTER MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DEXTER MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DEXTER MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DEXTER MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DONIPHAN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DONIPHAN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DONIPHAN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DONIPHAN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DONIPHAN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DUDLEY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DUDLEY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DUDLEY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DUDLEY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DUDLEY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]EAST PRAIRIE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]EAST PRAIRIE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]EAST PRAIRIE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]EAST PRAIRIE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]EAST PRAIRIE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FESTUS MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FESTUS MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FESTUS MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FESTUS MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FESTUS MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FREDERICKTOWN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FREDERICKTOWN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FREDERICKTOWN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FREDERICKTOWN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FREDERICKTOWN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GIDEON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GIDEON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GIDEON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GIDEON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GIDEON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GOLDEN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GOLDEN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GOLDEN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GOLDEN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GOLDEN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GREENVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GREENVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GREENVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GREENVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GREENVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HANNIBAL MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HANNIBAL MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HANNIBAL MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HANNIBAL MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HANNIBAL MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HAYTI MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HAYTI MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HAYTI MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HAYTI MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HAYTI MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HOLCOMB MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HOLCOMB MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HOLCOMB MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HOLCOMB MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HOLCOMB MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HOLLAND MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HOLLAND MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HOLLAND MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HOLLAND MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HOLLAND MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HORNERSVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HORNERSVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HORNERSVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HORNERSVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HORNERSVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JACKSON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JACKSON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JACKSON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JACKSON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JACKSON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JEFFERSON CITY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JEFFERSON CITY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JEFFERSON CITY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JEFFERSON CITY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JEFFERSON CITY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JOPLIN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JOPLIN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JOPLIN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JOPLIN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JOPLIN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]KENNETT MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]KENNETT MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]KENNETT MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]KENNETT MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]KENNETT MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]KOSHKONONG MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]KOSHKONONG MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]KOSHKONONG MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]KOSHKONONG MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]KOSHKONONG MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LEBANON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LEBANON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LEBANON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LEBANON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LEBANON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LILBOURN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LILBOURN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LILBOURN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LILBOURN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LILBOURN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MALDEN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MALDEN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MALDEN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MALDEN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MALDEN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MARSTON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MARSTON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MARSTON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MARSTON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MARSTON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MCBRIDE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MCBRIDE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MCBRIDE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MCBRIDE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MCBRIDE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MEXICO MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MEXICO MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MEXICO MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MEXICO MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MEXICO MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MOBERLY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MOBERLY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MOBERLY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MOBERLY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MOBERLY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MONETT MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MONETT MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MONETT MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MONETT MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MONETT MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MOUNTAIN GROVE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MOUNTAIN GROVE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MOUNTAIN GROVE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MOUNTAIN GROVE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MOUNTAIN GROVE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MOUNTAIN VIEW MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MOUNTAIN VIEW MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MOUNTAIN VIEW MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MOUNTAIN VIEW MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MOUNTAIN VIEW MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEELYS LANDING MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEELYS LANDING MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEELYS LANDING MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEELYS LANDING MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEELYS LANDING MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEOSHO MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEOSHO MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEOSHO MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEOSHO MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEOSHO MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEVADA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEVADA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEVADA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEVADA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEVADA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEW FLORENCE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEW FLORENCE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEW FLORENCE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEW FLORENCE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEW FLORENCE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEW MADRID MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEW MADRID MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEW MADRID MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEW MADRID MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NEW MADRID MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PARMA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PARMA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PARMA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PARMA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PARMA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PERRYVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PERRYVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PERRYVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PERRYVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PERRYVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]POPLAR BLUFF MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]POPLAR BLUFF MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]POPLAR BLUFF MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]POPLAR BLUFF MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]POPLAR BLUFF MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PORTAGEVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PORTAGEVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PORTAGEVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PORTAGEVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PORTAGEVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]QULIN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]QULIN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]QULIN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]QULIN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]QULIN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RAYMONDVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RAYMONDVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RAYMONDVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RAYMONDVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RAYMONDVILLE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ROLLA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ROLLA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ROLLA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ROLLA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ROLLA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SAINT CHARLES MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SAINT CHARLES MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SAINT CHARLES MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SAINT CHARLES MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SAINT CHARLES MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SAINT LOUIS MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SAINT LOUIS MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SAINT LOUIS MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SAINT LOUIS MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SAINT LOUIS MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SALEM MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SALEM MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SALEM MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SALEM MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SALEM MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCOTT CITY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCOTT CITY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCOTT CITY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCOTT CITY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCOTT CITY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SEDALIA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SEDALIA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SEDALIA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SEDALIA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SEDALIA MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SENATH MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SENATH MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SENATH MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SENATH MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SENATH MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SIKESTON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SIKESTON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SIKESTON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SIKESTON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SIKESTON MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SPRINGFIELD MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SPRINGFIELD MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SPRINGFIELD MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SPRINGFIELD MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SPRINGFIELD MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]STEELE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]STEELE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]STEELE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]STEELE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]STEELE MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]THAYER MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]THAYER MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]THAYER MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]THAYER MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]THAYER MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WASHBURN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WASHBURN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WASHBURN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WASHBURN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WASHBURN MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WEBB CITY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WEBB CITY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WEBB CITY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WEBB CITY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WEBB CITY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WEST PLAINS MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WEST PLAINS MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WEST PLAINS MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WEST PLAINS MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WEST PLAINS MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WILLOW SPRINGS MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WILLOW SPRINGS MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WILLOW SPRINGS MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WILLOW SPRINGS MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WILLOW SPRINGS MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WRIGHT CITY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WRIGHT CITY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WRIGHT CITY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WRIGHT CITY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WRIGHT CITY MO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
I assume you mean you wish to apply conditional formatting to ColA. So, your data begins in A1 down to A380 and B1 down to B47. Create a new CF rule using a formula to evaluate, applying the CF to A1:A380, and paste this in as the formula =SUM(--(A1=$B$1:$B$47)) > 0
 
Last edited by a moderator:
Upvote 0
I assume you mean you wish to apply conditional formatting to ColA. So, your data begins in A1 down to A380 and B1 down to B47. Create a new CF rule using a formula to evaluate, applying the CF to A1:A380, and paste this in as the formula =SUM(--(A1=$B$1:$B$47)) > 0

https://www.dropbox.com/s/zfdejeoey36oyiz/HELP TEST.xlsx?dl=0


I need the cities in column A to be highlighted, if they are in the list of cities in column B. That might make more sense.
 
Upvote 0
No, it doesn't. "Highlighted" means nothing in Excel.
 
Upvote 0
No formula come to my mind, but a VBA routine can do that. If you have some basic VBA knowledge put the following code in a standard module and assign a key combination to execute it.

Code:
Sub HighLight_Cities()
Dim Rng As Range
Dim rCell As Range
Dim rRng As Range
Dim uFila As Long
Dim CityName As String


uFila = Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row
Set rRng = Sheets("Sheet1").Range("A1:A" & uFila)


For Each rCell In rRng.Cells
    CityName = rCell.Value
    If Trim(CityName) <> "" Then
        With Sheets("Sheet1").Range("B:B")
            Set Rng = .Find(What:=CityName, _
                            After:=.Cells(.Cells.Count), _
                            LookIn:=xlValues, _
                            LookAt:=xlWhole, _
                            SearchOrder:=xlByRows, _
                            SearchDirection:=xlNext, _
                            MatchCase:=False)
            If Not Rng Is Nothing Then
                rCell.Interior.Color = vbYellow
            End If
        End With
    End If
Next rCell
End Sub
 
Upvote 0

Forum statistics

Threads
1,223,227
Messages
6,170,849
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top