I'm not sure what to tell you... if we are looking in Columns A, B and D for
identical content in each of the cells for a given column occurring 3 or
more time, then the code I posted works fine in my tests. Are you
remembering to select a range whose rows cover the rows you want to test for
your triples? You can send your workbook to me if you want and I would be
happy to look and see why you are having trouble with my code.... just
remove the NO.SPAM stuff from my email address.

--
Rick (MVP - Excel)



"Stefano" wrote in message
...
On Apr 6, 10:22 pm, "Rick Rothstein"
wrote:
@Rick Rothstein
just column A B D. Order is not important

If by that you mean this...

A B D
=== === ===
Rick Stefano Don

matches this....

A B D
=== === ===
Don Stefano Rick

then my posted code will not work for you.

--
Rick (MVP - Excel)

@Rick Rothstein
no...I'll always have "Rick"at A column.... but it still does not seem
to work...why?
Please let me know more...
I mean, if I start a new sheet and I write Rick, Stefano, Don,
respectively into column A, B, D, and i run the macro nothing became
highlighted...?
What I'm doing wrong?

Thank you very much indeed,
Stefano.