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