Do you mean identify the top, fill all instances of that yellow, all 2nd
green, etc?

If so, where is the names, and the item that constitutes top users?

--
HTH

Bob Phillips

"olimits7" wrote in
message ...

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