Quote Originally Posted by xld
Sorry, mis-read what you had written.

Do you want to bold the row when J changes and it is today, or whenever the value in J matches today's date?
No worries.
Actually - I got it! (by research - not brains).
[VBA]
Sub BoldToday()
Dim i As Long
Dim MyNew As Long
Application.ScreenUpdating = False
LR = Cells(Rows.Count, 1).End(xlUp).Row
For i = MyNew To 2 Step -1
If Range("J" & i).Value = Date Then
Range("J" & i).EntireRow.Font.Bold = True
End If

Next i
Application.ScreenUpdating = True

End Sub
[/VBA]