highlight consecutive duplicate rows (re-sending)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phil Hellmuth - 18 Jan 2008 17:10 GMT

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.

Reply to this Message

Dave Peterson - 18 Jan 2008 18:42 GMT

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

> My apologies if anyone responded to this when I originally posted. I
> didn't download enough headers and I can't recapture the original....
[quoted text clipped - 6 lines]
>
> Thanks in advance.

Signature

Dave Peterson

Reply to this Message

Gord Dibben - 18 Jan 2008 22:44 GMT

Why aren't you playing poker somewhere<g>

Gord Dibben MS Excel MVP

>My apologies if anyone responded to this when I originally posted. I
>didn't download enough headers and I can't recapture the original....
[quoted text clipped - 6 lines]
>
>Thanks in advance.

Reply to this Message