Sum, IF, Subtotal ???

[Allan Koodray]

Amy,

Use the following technique (assuming that your data
starts in cell A1):

Format --> Conditional Formatting...
Condition 1
Formula is =SUM($A$2:A$2)>650
Then Select the "Format" button to change the formatting
for values greater than 650. This will affect only cell
A2.

Copy cell A2
Highlight the rest of the cells
Edit --> Paste Special --> Formats

Allan
[email protected]

-----Original Message-----
Hello!

My goal is to identify at what point usage hours on

equipment reaches a certain amount. I am trying to chart
recommeded spare parts changes.

For example, I have two rows as follows. Row #1 date and

Row #2 equipment usage in hours.

Jan-05 Feb-05 Mar-05 Apr-05 May-05 Jun-05 Jul-05 ...
...

When row 2 reaches an accumulated 650 hours, I want to

identify this month (color, text, doesn't really matter
how). After reaching and identifying 650 hours of usage,
I need it to start again.

 

[Amy Lou]

Thanks Allan, this works as well up until I need it to reset every 650 hours.
Any suggestions?