Hello everyone!

I need some with conditional formatting in Excel. I have a lists of Cities and ID numbers. If an ID exists more than once for a city, then I want those entire rows to be highlighted.

See below for an example of what I am talking about.
http://amdusers.com/test.xls