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