highlight duplicate rows comparing two cells
 

This post follows on from Dave Peterson's reply 13/3/08.
I replied twice on the 14th but they seem not to have posted.

Dave your code will be good if I want to just see unique values but
can I please get some help to highlight all rows where col C LastName
and col D FirstName are the same.
I don't want to concatenate and advance filter as I want to be able to quickly search all records when deciding which duplicate to delete or to keep both/all (other columns
may differ).

I need to be able to use the code again so was thinking that it would
be put in a module in my personal.xls?

thanks again
Peta

highlight duplicate rows comparing two cells
 

RowCount = 1
Do While Range("C" & RowCount) < ""
If Range("C" & RowCount) = Range("D" & RowCount) Then
Rows(RowCount).Interior.ColorIndex = 6
End If
RowCount = RowCount + 1
Loop
" wrote:

This post follows on from Dave Peterson's reply 13/3/08.
I replied twice on the 14th but they seem not to have posted.

Dave your code will be good if I want to just see unique values but
can I please get some help to highlight all rows where col C LastName
and col D FirstName are the same.
I don't want to concatenate and advance filter as I want to be able to quickly search all records when deciding which duplicate to delete or to keep both/all (other columns
may differ).

I need to be able to use the code again so was thinking that it would
be put in a module in my personal.xls?

thanks again
Peta