I am looking to change the font color to blue if the last update date (in
column 19) is greater than yesterday. I have the code below in the macro but
it only runs for the row that is selected. It doesn't run through rows 2 to
1000. Any help is appreciated.

For rwIndex = 2 To 1000
For colIndex = 19 To 19
With Worksheets("CC Routed Truck Loads").Cells(rwIndex, colIndex)
If .Value = "" Then
Exit For
Else
If .Value Int(Now()) - 3 Then
Selection.EntireRow.Font.ColorIndex = 5
End If
End If
End With
Next colIndex
Next rwIndex