you could go to the first worksheet and next to the list of people you could
enter a formula like

ex: Cell B2
=if(sum(--(countif(Sheet2!A:A,A2)0),--(countif(Sheet3!A:A,A2)0),--(Countif
(sheet4!A:A,A2)0))=3,"All 4","No")

then drag fill this down the column. This assumes testing in Column A, but
you could choose more columns if need be.

--
Regards,
Tom Ogilvy

"Lynn" wrote in message
oups.com...
Hi,
I have 1 workbook which consists of 4 worksheets. The data in these
worksheets are names of people. Does anybody has a macro (or some ways)
to compare these 4 worksheets and highlight those names that exists in
all 4 worksheets ?
thanks