Record a macro while doing it


Regards,

Peo Sjoblom


"MaxNY23" wrote in message
...
I can't mark thousands of rows every month, I want Excel do do the
marking/matching via a formula or macro.

Anything else?


"Ron Rosenfeld" wrote:

On Wed, 22 Mar 2006 07:47:28 -0800, MaxNY23
You could mark entries which are duplicates by your rules. Would that be
OK.

For example, in a helper column or as a conditional formatting formula:

=COUNTIF($C$1:$C$10,B1&A1)

would be 1 or more if the reverse concatenation existed in column C


--ron