Hi,
I have the following code below which works exactly as I want it to:
If Cells(rowCount, 1).Value = Range("D2").Value And Not IsEmpty(Cells(rowCount, 1).Value) Then
Cells(rowCount, 14).Font.Color = vbRed
End If
But now I want to the = Range("D2").Value section.
Instead of if...