Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two search category & two search terms | Excel Discussion (Misc queries) | |||
file search or search files | Excel Discussion (Misc queries) | |||
Functions (search within search result) reply to this please | Excel Worksheet Functions | |||
Functions (search within search result) | Excel Worksheet Functions | |||
How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions |