Inventory Control

[Guest]

I have over 1000 small parts and need some sort of control showing when parts
are runing out and need to be reordered.

 

[Ola Sigurdh]

Hello Glenn

Do something like this. If you have your parts quantity in D1, in E1 type in
the quantity when you want to reorder tha part then highlight cell D1. Go to
format then choose conditiona formatting, choose cell value less than e1
then format it the way you want.

Ola