How to Set a Low Inventory Alert in Excel. Microsoft Excel software has a conditional formatting element that compares values between cells. This feature allows inventory clerks to set a minimum ...

Pair it with another inventory formula. The EOQ formula can be paired with the reorder point formula, which helps a business identify when it should order more inventory.

When the current inventory dips below (or is equal to) the reorder amount, Excel highlights that cell. With a quick glance, you can determine which items to order.