Thanks. Those responses gave me some ideas. Will try it as =Min-End, and
condition format it to show only if or= 1.
Thanks again.
Alan

"Walid M. Bahgat" wrote:

1) Format menu -- Conditional Formatting
2) Select "Formula Is" instead of "Cell Value is" then write the following
formula that assumes that the stock is column "A"
3) =B1<min(A:A)

"Alan" wrote:

I am trying to set up an automatic re-order system where the re-order column
shows the re-order amount in Red only when the End Balance column is less
than the Minimum Stock column. How do I do that?