highlight consecutive duplicate rows (re-sending)

[Phil Hellmuth]

My apologies if anyone responded to this when I originally posted. I
didn't download enough headers and I can't recapture the original....

I want to highlight any row that has the same data as the previous row.
For example, if A:3=A:2 and B:3=B:2 and C:3=C:2, I want to highlight
Row 3. I also want to repeat this logic throughout the spreadsheet.
Can I do with this with Conditional Formatting? Or, would I need to use
VBA...in which case, how would I code this?

Thanks in advance.

 

[Dave Peterson]

I have no idea if anyone responded to your earlier post, but you could check
yourself:

You can use google (maybe a few hours behind) to search for stuff you've
posted (and find the replies, too)

http://groups.google.com/advanced_group_search
http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100

Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm

 

[Gord Dibben]

Why aren't you playing poker somewhere<g>


Gord Dibben MS Excel MVP