Excel Formatting/Formulas help

[Jeff]

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

[spikey_richie]

I think you'd have to do this via a macro, which then has it's own issues with absolute cell referencing.

Have a look on here:

http://www.excelforum.com/

Edit - you could do something like this http://www.contextures.com/xlCondFormat02.html and use = rather than <>

[NeoGen]

I found this and it solved the problem:
http://office.microsoft.com/en-us/ex...366161033.aspx

After a few tries with your test worksheet, and setting the right fixed references, a formula worked.
I selected the whole range you have there and applied the following formula in conditional formatting:
=COUNTIF($K$2:$K$25;$K2)>1

The result is that all lines that were painted yellow, became red (by conditional formatting). Check the attached file.

[Beerknurd]

You guys are a bunch of damn geniuses...

[Ototero]

Correct answer Neo, I love excel

[Jeff]

Thanks for the help. That did it!