Find

I

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.
ARBYRD MOARBYRD MO
ARBYRD MOHORNERSVILLE MO
ARBYRD MOCOOTER MO
ARBYRD MOHOLLAND MO
ARBYRD MOCARDWELL MO
AVA MORIVES MO
AVA MOSTEELE MO
AVA MOGOBLER MO
AVA MOSENATH MO
AVA MOCARUTHERSVILLE MO
BALLWIN MOBRAGGADOCIO MO
BALLWIN MODEERING MO
BALLWIN MOKENNETT MO
BALLWIN MOBRAGG CITY MO
BALLWIN MOHAYTI MO
BERNIE MOWHITEOAK MO
BERNIE MOWARDELL MO
BERNIE MOHOLCOMB MO
BERNIE MOCLARKTON MO
BERNIE MOGIBSON MO
BIRCH TREE MOPORTAGEVILLE MO
BIRCH TREE MOGIDEON MO
BIRCH TREE MOCAMPBELL MO
BIRCH TREE MOTALLAPOOSA MO
BIRCH TREE MORISCO MO
BISMARCK MOMALDEN MO
BISMARCK MOMARSTON MO
BISMARCK MOQULIN MO
BISMARCK MONEELYVILLE MO
BISMARCK MOLILBOURN MO
BLOOMFIELD MOPARMA MO
BLOOMFIELD MONAYLOR MO
BLOOMFIELD MONEW MADRID MO
BLOOMFIELD MOCATRON MO
BLOOMFIELD MOOXLY MO
BLOOMSDALE MOBERNIE MO
BLOOMSDALE MOBROSELEY MO
BLOOMSDALE MOKEWANEE MO
BLOOMSDALE MOHARVIELL MO
BLOOMSDALE MOFAIRDEALING MO
BRANDSVILLE MOCANALOU MO
BRANDSVILLE MODEXTER MO
BRANDSVILLE MOPOPLAR BLUFF MO
BRANDSVILLE MOGATEWOOD MO
BRANDSVILLE MOFISK MO
BRANSON MODUDLEY MO
BRANSON MODONIPHAN MO
BRANSON MO
BRANSON MO
BRANSON MO
CABOOL MO
CABOOL MO
CABOOL MO
CABOOL MO
CABOOL MO
CAMPBELL MO
CAMPBELL MO
CAMPBELL MO
CAMPBELL MO
CAMPBELL MO
CAPE GIRARDEAU MO
CAPE GIRARDEAU MO
CAPE GIRARDEAU MO
CAPE GIRARDEAU MO
CAPE GIRARDEAU MO
CARDWELL MO
CARDWELL MO
CARDWELL MO
CARDWELL MO
CARDWELL MO
CARTHAGE MO
CARTHAGE MO
CARTHAGE MO
CARTHAGE MO
CARTHAGE MO
CARUTHERSVILLE MO
CARUTHERSVILLE MO
CARUTHERSVILLE MO
CARUTHERSVILLE MO
CARUTHERSVILLE MO
CHARLESTON MO
CHARLESTON MO
CHARLESTON MO
CHARLESTON MO
CHARLESTON MO
CLARKTON MO
CLARKTON MO
CLARKTON MO
CLARKTON MO
CLARKTON MO
COLUMBIA MO
COLUMBIA MO
COLUMBIA MO
COLUMBIA MO
COLUMBIA MO
COOTER MO
COOTER MO
COOTER MO
COOTER MO
COOTER MO
DEXTER MO
DEXTER MO
DEXTER MO
DEXTER MO
DEXTER MO
DONIPHAN MO
DONIPHAN MO
DONIPHAN MO
DONIPHAN MO
DONIPHAN MO
DUDLEY MO
DUDLEY MO
DUDLEY MO
DUDLEY MO
DUDLEY MO
EAST PRAIRIE MO
EAST PRAIRIE MO
EAST PRAIRIE MO
EAST PRAIRIE MO
EAST PRAIRIE MO
FESTUS MO
FESTUS MO
FESTUS MO
FESTUS MO
FESTUS MO
FREDERICKTOWN MO
FREDERICKTOWN MO
FREDERICKTOWN MO
FREDERICKTOWN MO
FREDERICKTOWN MO
GIDEON MO
GIDEON MO
GIDEON MO
GIDEON MO
GIDEON MO
GOLDEN MO
GOLDEN MO
GOLDEN MO
GOLDEN MO
GOLDEN MO
GREENVILLE MO
GREENVILLE MO
GREENVILLE MO
GREENVILLE MO
GREENVILLE MO
HANNIBAL MO
HANNIBAL MO
HANNIBAL MO
HANNIBAL MO
HANNIBAL MO
HAYTI MO
HAYTI MO
HAYTI MO
HAYTI MO
HAYTI MO
HOLCOMB MO
HOLCOMB MO
HOLCOMB MO
HOLCOMB MO
HOLCOMB MO
HOLLAND MO
HOLLAND MO
HOLLAND MO
HOLLAND MO
HOLLAND MO
HORNERSVILLE MO
HORNERSVILLE MO
HORNERSVILLE MO
HORNERSVILLE MO
HORNERSVILLE MO
JACKSON MO
JACKSON MO
JACKSON MO
JACKSON MO
JACKSON MO
JEFFERSON CITY MO
JEFFERSON CITY MO
JEFFERSON CITY MO
JEFFERSON CITY MO
JEFFERSON CITY MO
JOPLIN MO
JOPLIN MO
JOPLIN MO
JOPLIN MO
JOPLIN MO
KENNETT MO
KENNETT MO
KENNETT MO
KENNETT MO
KENNETT MO
KOSHKONONG MO
KOSHKONONG MO
KOSHKONONG MO
KOSHKONONG MO
KOSHKONONG MO
LEBANON MO
LEBANON MO
LEBANON MO
LEBANON MO
LEBANON MO
LILBOURN MO
LILBOURN MO
LILBOURN MO
LILBOURN MO
LILBOURN MO
MALDEN MO
MALDEN MO
MALDEN MO
MALDEN MO
MALDEN MO
MARSTON MO
MARSTON MO
MARSTON MO
MARSTON MO
MARSTON MO
MCBRIDE MO
MCBRIDE MO
MCBRIDE MO
MCBRIDE MO
MCBRIDE MO
MEXICO MO
MEXICO MO
MEXICO MO
MEXICO MO
MEXICO MO
MOBERLY MO
MOBERLY MO
MOBERLY MO
MOBERLY MO
MOBERLY MO
MONETT MO
MONETT MO
MONETT MO
MONETT MO
MONETT MO
MOUNTAIN GROVE MO
MOUNTAIN GROVE MO
MOUNTAIN GROVE MO
MOUNTAIN GROVE MO
MOUNTAIN GROVE MO
MOUNTAIN VIEW MO
MOUNTAIN VIEW MO
MOUNTAIN VIEW MO
MOUNTAIN VIEW MO
MOUNTAIN VIEW MO
NEELYS LANDING MO
NEELYS LANDING MO
NEELYS LANDING MO
NEELYS LANDING MO
NEELYS LANDING MO
NEOSHO MO
NEOSHO MO
NEOSHO MO
NEOSHO MO
NEOSHO MO
NEVADA MO
NEVADA MO
NEVADA MO
NEVADA MO
NEVADA MO
NEW FLORENCE MO
NEW FLORENCE MO
NEW FLORENCE MO
NEW FLORENCE MO
NEW FLORENCE MO
NEW MADRID MO
NEW MADRID MO
NEW MADRID MO
NEW MADRID MO
NEW MADRID MO
PARMA MO
PARMA MO
PARMA MO
PARMA MO
PARMA MO
PERRYVILLE MO
PERRYVILLE MO
PERRYVILLE MO
PERRYVILLE MO
PERRYVILLE MO
POPLAR BLUFF MO
POPLAR BLUFF MO
POPLAR BLUFF MO
POPLAR BLUFF MO
POPLAR BLUFF MO
PORTAGEVILLE MO
PORTAGEVILLE MO
PORTAGEVILLE MO
PORTAGEVILLE MO
PORTAGEVILLE MO
QULIN MO
QULIN MO
QULIN MO
QULIN MO
QULIN MO
RAYMONDVILLE MO
RAYMONDVILLE MO
RAYMONDVILLE MO
RAYMONDVILLE MO
RAYMONDVILLE MO
ROLLA MO
ROLLA MO
ROLLA MO
ROLLA MO
ROLLA MO
SAINT CHARLES MO
SAINT CHARLES MO
SAINT CHARLES MO
SAINT CHARLES MO
SAINT CHARLES MO
SAINT LOUIS MO
SAINT LOUIS MO
SAINT LOUIS MO
SAINT LOUIS MO
SAINT LOUIS MO
SALEM MO
SALEM MO
SALEM MO
SALEM MO
SALEM MO
SCOTT CITY MO
SCOTT CITY MO
SCOTT CITY MO
SCOTT CITY MO
SCOTT CITY MO
SEDALIA MO
SEDALIA MO
SEDALIA MO
SEDALIA MO
SEDALIA MO
SENATH MO
SENATH MO
SENATH MO
SENATH MO
SENATH MO
SIKESTON MO
SIKESTON MO
SIKESTON MO
SIKESTON MO
SIKESTON MO
SPRINGFIELD MO
SPRINGFIELD MO
SPRINGFIELD MO
SPRINGFIELD MO
SPRINGFIELD MO
STEELE MO
STEELE MO
STEELE MO
STEELE MO
STEELE MO
THAYER MO
THAYER MO
THAYER MO
THAYER MO
THAYER MO
WASHBURN MO
WASHBURN MO
WASHBURN MO
WASHBURN MO
WASHBURN MO
WEBB CITY MO
WEBB CITY MO
WEBB CITY MO
WEBB CITY MO
WEBB CITY MO
WEST PLAINS MO
WEST PLAINS MO
WEST PLAINS MO
WEST PLAINS MO
WEST PLAINS MO
WILLOW SPRINGS MO
WILLOW SPRINGS MO
WILLOW SPRINGS MO
WILLOW SPRINGS MO
WILLOW SPRINGS MO
WRIGHT CITY MO
WRIGHT CITY MO
WRIGHT CITY MO
WRIGHT CITY MO
WRIGHT CITY MO

<colgroup><col><col></colgroup><tbody>
</tbody>
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Sort by date Sort by votes
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
DRSteele said:
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
Click to expand...

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
You must log in or register to reply here.

Forum statistics

Threads
1,214,922
Messages
6,122,281
Members
449,075
Latest member
staticfluids

Share this page

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