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