Select your cells from Row 2 down as far as will be needed and use this
formula in the Format Condition...

=H2+5<=TODAY()

--
Rick (MVP - Excel)


"Matthew Dyer" wrote in message
...
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?