Hi Steve,

The OP stipulated:

automatically highlighting rows that had a date within the past 7 days?


Your formula would appear to encompass a 16 day period which includes days
before and after today.


---
Regards,
Norman


"STEVE BELL" wrote in message
news:p1RCe.12112$ph1.42@trnddc06...
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.