Select column A, Format, Conditional format, Formula is,
=countif(B:B,A1)
then select your cell colour

Select column B, Format, Conditional format, Formula is,
=countif(A:A,B1)
then select your cell colour

--

chief775 Wrote:
Is it possible to compare two columns of data in Excel. For example if
I
have two columns of names A & B, with column A containing 5,000 names
and
column B containing 1,000 names, how would I compare B to A.
Additionally,
would it be possible to then conditionally format the duplicated item
in
Column B, maybe make it bold or red?

Thanks

Howard


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=531738