If you maintain inventory in an Excel worksheet, you probably need to know when stock runs low so you can reorder. Fortunately, you can let Excel warn you when an item is running low by applying a ...

How to Set a Low Inventory Alert in Excel. ... on the left under Condition1 and select "Formula is." ... in the actual inventory cell whenever your logged inventory slips below your reorder level.