Highlight cells if duplicate found on the same row

[martinez_pedro]

I have no idea how to even start this macro but i will like the macro to find duplicate with thin the same row and highlight it i have done with conditional formatting but the spreadsheet is about 3000 rows excel performance is super slow if anybody has a macro out there i will really appreciate thanks

[royUK]

You don't need VBA, use Conditional Formatting

[martinez_pedro]

I will like to do it with a macro because excel performance is not so slow
conditional formatting takes all my excel resources

[stanleydgromjr]

martinez_pedro,

Based on your example workbook, your are looking to highlite duplicates of values in column A in each respective row.

See the attached workbook "Highlight cells if duplicate found on the same row - EXAMPLE(1) - martinez_pedro - VP rows - SDG10.xls" with macro "FindMatches".

Detach the workbook and run the "FindMatches" macro on Sheet1.

The macro will run in Excel 2003 and 2007.

[martinez_pedro]

hey stan thanks for the help i guess my exemple wasnt very clear but
let me described in another words
So let say on sheet1
On row 2 cell a2 and cell f2 is a match then highlights a2&f2
On row 3 cell b3 and cell d3 is a match then highlights b3&d3
On row 4 cell z4and cell aa4 is a match then highlight z4&aa4
On row 5 cell f5 and cell h5 is a match then highlights f5&h5
On row 6 cell i6 and cell q6 is a match then highlights i6&q6
The matching cells can be anywhere on the row and blank cell needs to exclude it for highlighting

[stanleydgromjr]

martinez_pedro,

How about another sample workbook with raw data (say 10 rows) on Sheet1, and on Sheet2 what the results should be.

What if you have on one row two different sets of two cells or more?

[Leith Ross]

Hello martinez_pedro,

I have added the following macro to the attached workbook. There is an example on "Sheet2". A button has been added to run the macro.

The macro assumes the first row contain column headers and there are no empty rows in the table. Empty cells are not marked as duplicates.

Please Login or Register  to view this content.

[stanleydgromjr]

Leith Ross,

Nicely done.

[satswid]

This code must help in almost every worksheet

Please Login or Register  to view this content.

[martinez_pedro]

Excellent work (satswid, Leith Ross, stanleydgromjr, royUK) both of this macros works really good thank you, you all save a lot of time

[rkb]

This code must help in almost every worksheet

Please Login or Register  to view this content.

When i am using the code i am getting a error "Type Mismatch"

can any one solve this issue