On Jul 17, 9:02*am, Don Guillett wrote:
On Jul 17, 4:49*am, Claus Busch wrote:







Hi Mario,

Am Sun, 17 Jul 2011 19:14:29 +1000 schrieb Mario:

I have a list of 200 club members in say A1 to A200.

I would like to type in a name in say C1 and have Excel search the list
and highlight the name in the list if it finds it.

select A1:A200 = Format = Conditional Formatting = formula:
=COUNTIF(A1,$C$1)0

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Sub ModfiedFindc1() 'Still Simple
On Error Resume Next
Columns("A").Find(What:=Range("c1"), _
LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False, _
SearchFormat:=False).Activate
End Sub