Need help with a forcasting type problem
Hi,
Lets suppose your day runs from B1:B31:
To conditionally format your cell(s):
In 2003:
1. Select the cell you want to format
2. Choose Format, Conditional Formatting
3. Choose Formula is from the first drop down
4. In the second box enter the formula:
=SUM(B$1:B1)10000
5. Click the Format button
6. Choose a color on the Patterns tab (or any available option)
7. Click OK twice.
In 2007:
1. Highlight all the cells on the rows you want formatted
2. Choose Home, Conditional Formatting, New Rule
3. Choose Use a formula to determine which cell to format
4. In the Format values where this formula is true enter the following
formula:
=SUM(B$1:B1)10000
5. Click the Format button and choose a format.
6. Click OK twice
If this helps, please click the Yes button.
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
|