Sub AddColour()
Dim rngJ As Range, rngBT As Range
For Each rngJ In Range("J1:J" & Range("J65536").End(xlUp).Row)
For Each rngBT In Range("BT1:BT" & Range("BT65536").End(xlUp).Row)
If rngJ.Text = rngBT.Text Then
Range("U" & rngJ.Row).Interior.Color = 100
End If
Next
Next
End Sub
初学者,多指教!
Sub AddColour()
Dim rngJ As Range, rngBT As Range
For Each rngJ In Range("J1:J" & Range("J65536").End(xlUp).Row)
For Each rngBT In Range("BT1:BT" & Range("BT65536").End(xlUp).Row)
If rngJ.Text = rngBT.Text Then
Range("U" & rngJ.Row).Interior.Color = 100
End If
Next
Next
End Sub
初学者,多指教!