Highlight Duplicates on same row

[bigroo1958]

Can I get some assistance here.

So, on my attachment, on the tab named start, I receive a file with thousands of rows.
I want to look at column D and if the name repeats on the next row, then look over at column B and if the dates are the same for both rows, then highlight these two cells in each column.

The tab named "end result" is what I am looking for.
I want a formula and a VBA solution if possible, but prefer a VBA solution.

Thanks

[AliGW]

Via formula, you would need this CF rule for columns B and D

=COUNTIFS($B$2:$B$31,$B2,$D$2:$D$31,$D2)>1

[JieJenn]

VBA Solution.

Please Login or Register  to view this content.

[JieJenn]

Via formula, you would need this CF rule for columns B and D

=COUNTIFS($B$2:$B$31,$B2,$D$2:$D$31,$D2)>1

Unfortunately, COUNTIFS wouldn't work as his date value contains different time values.

[AliGW]

I've just noticed that!!!

[jindon]

The tab named "end result" is what I am looking for.

If you want the consecutive pairs as your result.

Please Login or Register  to view this content.

[Fluff13]

With a CF formula

Please Login or Register  to view this content.

[Marc L]

[…] but prefer a VBA solution.

According to your attachment a tiny starter demonstration :

Sub Demo1() 
             Dim Rw As Range 
    With Sheets("Start").[A1].CurrentRegion.Rows 
        For Each Rw In .Item("3:" & .Count) 
          If Fix(Rw.Cells(2).Value2) = Fix(Rw.Cells(2)(0).Value2) Then _ 
              If Rw.Cells(4).Value2 = Rw.Cells(4)(0).Value2 Then Rw(0).Range("B1:B2,D1:D2").Interior.Color = vbYellow 
        Next 
    End With 
End Sub  

Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

[bigroo1958]

Thank you all for the very quick solutions to my request, it is very much appreciated.
All the solutions work nicely and provide me the results wanted.

I am in the process of learning more on VBA and it was nice to see the different code examples.
Thanks

[Fluff13]

You're welcome & thanks for the feedback