Scheduling Functions

[mcklein]

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.

 

[Mathew P Bennett]

How about conditional formatting

 

[Storm]

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

 

[Gary''s Student]

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

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

 

[Gary Brown]

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()