View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] shaunholtz21@hotmail.com is offline
external usenet poster
 
Posts: 2
Default Conditional formatting and Highlighting Date Range

HI -

I have what I thought would be simple, however I can't seem to figure
this out. Here's what I have, simply I have several Columns, D1:T1
with a date listed in each. All i'm trying to do it highlight cells
that contain a date(s) within the next 7 day's. Not the Current week
or Next week. 7 days from today. Excel 2007 has build in formatting
for some of it. but not an option for what I need. Can someone help?

Thanks!
Any help would be greatly appreciated.