Forum Discussion
excel formulas
Hi, I am trying to set up an inventory sheet in excel. I would like to write a formula that will indicate when a product is under a certain amt and therefore needs to be reordered. Ex: Amt ...
Hi pegandlilly
You can do something as simple as selecting the cells in the Reorder column and clicking onto Home tab > Conditional Formatting > Highlight Cell Rules > Less Than and ensuring that the value is 60.
Change for format option to Red text and that will only show up if the value meets the criteria.
This will make any cell that doesn't meet the criteria as red!
Hope that helps give you a start.
Cheers
Damien