Hi,

how is your data laid out?

Cheers,
Shane Devenshire


"Brake-Man2008" wrote:

I am trying to have excel do a few automatic calculations for me. In the
problem I am trying to solve I have the following:

Given:
Month (day 1-31)
production each day (ranges from 0-3000 value is linked from another file)
life of a tool (consider 10,000 before it needs changed)

Find:
Have a cell change color using (format cell) when tool life is up.

I have been able to do this for an entire month worth of projected
production (dividing it evenly into the number of production days) but have
not been able to use a forcast funtion. I really do not care what funtion I
use to do this just that I can expand this into a larger project with
multiple tools (say 75) each with the posibility of differnt life
expectancies. Thanks for any help someone can offer.

--
Brake-Man2008