Below is the macro I use
I search names and if they match I color them.
Cells.FindNext(After:=ActiveCell).Activate
Cells.Find(What:="mount zion", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False...