need help leaning or restructuring macro for highlighighting duplicates on large data

[estatefinds]

I ran it but the code is placing the color red where they belong but some are off the data below the data.


also note the data in column C starts at row 5 and continues to about row 9000and the data in column G starts at row 5 and continues all the way down to 324632. The data in the file attached is just a small example as the one I’m using isto big to attach.

Sub DupFinder()Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
Application.DisplayStatusBar = False
Application.EnableEvents = False


    Dim R As Range, t As Range


    Set t = Range("C5:G324636")
    
    For Each R In t.SpecialCells(xlCellTypeConstants).Cells
        If Application.WorksheetFunction.CountIf(t, R.Value) > 1 Then
            R.Interior.ColorIndex = 3
        End If
    Next
    
Application.ScreenUpdating = True
Application.DisplayStatusBar = True
Application.EnableEvents = True
Application.Calculation = xlCalculationAutomatic
    
End Sub

Itried this and disabled all background running programs and still its slow.
need help to lean this macro please