Using Conditional Formating, highlight the columns you want to have
highlighted. Assuming Column B has the due dates and you want to highlight
anything that is one week or less out, set 'Formula Is' to...
=$B1-7<NOW()

--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"mcklein" wrote:

I'm creating a spreadsheet to track approaching deadlines for tasks to be
completed (on a construction project). I'm trying to figure out if there is a
function/formula that I can use to highlight cells as the dates approach. For
example, if today is 8/15/08, all cells that contain a 8/22/08 date or closer
would be highlighted.

Any help would be much appreciated.