Search Box
 

Hi,
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.

If C1 is blank then nothing in the list is highlighted.
I have no knowledge of macros or the implementation of macros
so the simplest solution might be better.
Please help.


I'm using
Microsoft Excel 2003

Search Box
 

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

Search Box
 

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

Search Box
 

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

Search Box
 

On Jul 17, 5:14*am, "Mario" wrote:
Hi,
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.

If C1 is blank then nothing in the list is highlighted.
I have no knowledge of macros or the implementation of macros
so the simplest solution might be better.
Please help.

I'm using
Microsoft Excel 2003

Just do a CTL-F and type in a name and click search.

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel