Use Conditional Formating.

This works automatically and doesn't require code.
The condition would have to apply to all cells in the row.

Select the total range. Change $A1 to the first cell in the
range.

Suggested formula might be (with date in column A)

Formula = "=ABS($A1-NOW())<8"
(remove quotes)

--
steveB

Remove "AYN" from email to respond
"Al Franz" wrote in message
...
Using the latest version of Excel on WinXP. Have a spreadsheet which has
a date in one of the fields. What would be the best way to go about
automatically highlighting rows that had a date within the past 7 days?
Any help would be appreciated.