Hello,

I have a spreadsheet that shows the top ten cell phone users for each
month, and I would like to apply some type of conditional formatting so
it highlights all the duplicate names each with its own color.

For example:

John Smith = Fill Yellow
Jack Johnson = Fill Green

Does someone know a way I could do this?

Thanks,

Olimits7


--
olimits7
------------------------------------------------------------------------
olimits7's Profile: http://www.excelforum.com/member.php...o&userid=15879
View this thread: http://www.excelforum.com/showthread...hreadid=394588