I am having trouble trying to compare dates that are in a worksheet cell
against a date placed in a Textbox. Here's the code:

If Cells(Drow, 5).Value < TextStart.Value And Not (Left(Cells(Drow,
10).Value, 1) Like "[D]") Then
Rows(Drow).Select
Selection.Interior.ColorIndex = 34
End If

The problem is that it changes all the cells to colorindex 34. I need it to
only change the colorindex of those rows that are prior to the textStart.value

Thanks in advance