How do I show cell A red when cell B less than cell C (Excel)

A

Alan

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

bigwheel

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.
 
W

Walid M. Bahgat

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)
 
A

Alan

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
 
A

Alan

Thanks guys. It worked.

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

Works like a charm.
Alan.
 
Top