Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My range of data has date values in column H (row 1 is header) for the
last time a file was worked. it is in DD-MMM-YY format (ex 23-NOV-09). What I'd like to do is run a macro that will bold a row if the date in column H is 5 days old or older. I have no idea how to do this with dates... I tried to re-format column H into number "0" format and use Now to get today's day and change that into a "0" format as well to do my comparison but that failed as well. Help... please? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF(AND with date comparison | Excel Worksheet Functions | |||
Date Comparison | Excel Discussion (Misc queries) | |||
Date comparison | Excel Worksheet Functions | |||
Date Comparison | Excel Programming | |||
VBA: Date Comparison | Excel Programming |