Sub aa()
Dim rng As Range
For Each rng In Range("c602:az602")
If rng.Value = Range("b602").Value Then
rng.Interior.ColorIndex = 3
Else
rng.Interior.ColorIndex = 0
End If
Next
End Sub
Sub aa()
Dim rng As Range
For Each rng In Range("c602:az602")
If rng.Value = Range("b602").Value Then
rng.Interior.ColorIndex = 3
Else
rng.Interior.ColorIndex = 0
End If
Next
End Sub