Home

excel formulas

pegandlilly
Occasional Visitor

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 on hand   Amt Used   Amt Remaining   Reorder if Amt remaining column is less than 60 

            80                    40                 40

 

Can you help me with this please?

2 Replies

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.

 

capture20181001131534278.png

 

This will make any cell that doesn't meet the criteria as red!

 

Hope that helps give you a start.

 

Cheers

Damien

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies