Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking if something is past due
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking if something is past due
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" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Past due function | Excel Worksheet Functions | |||
Past 30 montha | Charts and Charting in Excel | |||
Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
Checking range of cells for entry then checking for total | Excel Programming | |||
Look up & past value | Excel Programming |