How do I show cell A red when cell B less than cell C (Excel)
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? |
How do I show cell A red when cell B less than cell C (Excel)
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? |
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? |
How do I show cell A red when cell B less than cell C (Excel)
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? |
How do I show cell A red when cell B less than cell C (Excel)
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? |
All times are GMT +1. The time now is 06:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com