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?