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?

Are you comparing dates in column C with a variable date input or just
today's date? Do the dates in column C include only dates in the past or do
they include future dates?

When you say "Open" for column H, are you referring to a stock price or the
text "Open"?

"Jonathan" <(E-Mail Removed)> wrote in message
news:FA1C39D8-F857-467B-847D-(E-Mail Removed)...
> 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?

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?