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" <olimits7.1tjxis_1123682728.5994@excelforum-nospam.com> wrote in
message news:olimits7.1tjxis_1123682728.5994@excelforum-nospam.com...
>
> 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
>