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.

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.

Conditional formatting. Excel help will tell you how.
--
David Biddulph

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

Have you tried using the conditional formatting option? Go to the cell you
want to highlight. Then go to Format menu and select "Conditional
Formatting".

You can then put in your conditions. I would try leaving Condition 1 as a
formula and put in "=E6-TODAY()<=7" where 7 is the number of days max from
today's date that you want to highlight. Then click on the "Format" button
and select patterns and choose your color.

What this will do is apply the format if your condition is met.

Try that and see if this is what you are looking for.

Storm

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

The usual approach for this is to use Conditional Formatting. See:

http://www.contextures.com/xlCondFormat01.html

--
Gary''s Student - gsnu200800


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

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.