How do I show cell A red when cell B less than cell C (Excel)
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?
|