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?

Conditional formatting will achieve this. e.g. if you consider this example

reorder min end
200 50 49

click on the cell containing the reorder value, then click Format,
Conditional Formatting and change the Condition to "Formula Is" then enter
the formula
=C2<B2 then click the Format button and choose the color you want the
reorder cell to be.

"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?

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?

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?

Thanks guys. It worked.

(1) Format MenuCondition Format
(2) Condition 1:Formula is=End Bal<Min, Format is Bold Red.
(3) Condition 2:Formula is=End BalMin, Format is Clear.
(4) Condition 3:Formula is=End Bal=Min, Format is Clear.

Works like a charm.
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?