How about conditional formatting
"mcklein" wrote in message
...
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.