Excel Macro for Max / Min

How about using conditional formatting to make the cells values change to different colors when they exceed the min/max?

How about a formula like this IF(A1=MAX($A$1:$A$30),"WHOABUDDY","LITTLEFISH") in the adjacent column? The min would be similar. Or you could put them together in an OR statement in the IF statement.

This is the most simple, usefull solution.

It is sufficient for you ?

thanks the conditional formating will work just fine. I keep learning and am thankful that I can

Best regards

RW

rwindbigler, you could try this.

Somewhere on you spreadsheet place the values for MIN QTY and MAX QTY in separate cells, lets say A1 and A2 respectively.

Say you have your running total in column D.

Say you last total is in cell D31. In column E, next to your last total enter the following formula:

IF(D31<=A1,"PRODUCE MORE",IF(D31>=A2,"STOP PRODUCTION","INVENTORY OK"))

Then as you enter + and - you can drag the formula in E down.

Thank you I will work with that formula, it sounds like a good one.

RW

rwindbigler, one more item you need in your formula, for cell references to your MIN and MAX, the A1 and A2, you will need to lock the cell reference or it will roll up when you drag the formula down. So they should be $A$1 and $A$2

Grimale ( waiting for e-mail to complete registration on CR4 )

I would put a button on the sheet, and run a vba macro that loops through the inventory list, and generates a report (copied to a separate sheet) that can be printed and used to correct the issues listed.

if interested, let me know, I'll show you how to code it.

chris

Chris:

I've been following this thread from a "I might be able to use that sometime later" standpoint, but I may have missed something. Are the errors you would report of the "wrong data" variety, or are they of the "this step has an (or this specific, even) error"?

Either would be useful to me, and I would like any help you could offer, but a program checker would be of more value.

Micah

Read up on CONDITIONAL FORMATTING, this will achieve what you want.

There are some nice automatic condtional formats in excel 2007, you can actually put micro-bar-graphs in the cells showing their rank, or colored dots for min and max values of the selected range etc etc etc.

Very good ideas and suggestions it has helped.