Hi,
you can use conditional formating to highlight let' say in red a cell when
the stock reaches the minimun, for example in A1 you have a formula that
populate your stock level then with conditional formating, choose less than
there enter the minimun requiered for example 1000 and then choose the color
you want the cell to have
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.