Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

Highlighting Duplicates.

Posted by George on January 21, 2002 11:51 AM
I have data in 2 columns next to each other (A & B)

I need a way of searching the columns and highlighting the row(s) which contain the same values in column A & B.

Any ideas?

Thanks
George


Re: Highlighting Duplicates.

Posted by Tom Urtis on January 21, 2002 12:49 PM
George,

See if Conditional Formatting helps you in this case. Highlight your range in column A, then click on Format > Conditional Formatting, under Condition 1 choose Formula is, and in the field to the right of that enter =A2=B2. Click the Format button, Patterns tab, and choose your highlight color. Click OK, then OK again.

Highlight the corresponding range in column B, and follow the same steps, but this time enter the formula =B2=A2.

These formulas assume your columns' data starts in row 2, and that you highlight the columns' data beginning with row 2.

HTH
Tom Urtis


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.