Checking if something is past due
This should do the trick.
If Cells(Row, 8) = "Open" Then
If VBA.DateValue(Cells(Row, 3)) VBA.Now Then
Cells(Row, 3).EntireRow.Interior.ColorIndex = 6
End If
End If
"Jonathan" wrote:
I'm adding a function to an old Excel Macro. Basically, if Column H contains
Open and the date in Column C has passed, he wants the row to highlight
yellow. How do you check to see if a date has passed?
|