Hi Al,

Try conditional formatting, usung a formula like:

=AND($A1TODAY()-7,$A1<TODAY()+1)
---
Regards,
Norman



"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.