I am using excell to keep track of my production schedule
and I wanted to know if there was a way to tie the cells
in a worksheet to the internal date and time in the
computer,so that the cells will update automatically.
Example: Row A10 would be my production start date, Row
A1 would be my projected finish date, I would like the
cells in between to go from green to red as I near the
finish date without manually inputting the date in each
cell. Can you help me? Thyanks

Set the normal format as desired (I selected a Pattern of Green).

Select A1:A10, then select Format | Conditional Formatting... Set the
first drop down to Formula Is. In the 2nd text field enter
=($A$1-$A$10)/ROWS($A$1:$A$10)*(ROWS($A$1:$A$10)-ROW())+$A$10<=TODAY()

Click the Format... button and set the format as desired (I chose a
Pattern of red).

For test purposes, I used $C$1 instead of TODAY(). Then, I changed C1
to different dates and watched as A10->A1 turned from green to red.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Business solutions leveraging technology
Microsoft Most Valuable Professional (MVP) 2000-2004

In article <34a401c4294b$c0e25180$(E-Mail Removed)>, (E-Mail Removed)
says...
> I am using excell to keep track of my production schedule
> and I wanted to know if there was a way to tie the cells
> in a worksheet to the internal date and time in the
> computer,so that the cells will update automatically.
> Example: Row A10 would be my production start date, Row
> A1 would be my projected finish date, I would like the
> cells in between to go from green to red as I near the
> finish date without manually inputting the date in each
> cell. Can you help me? Thyanks
>