Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Inventory Control
I have over 1000 small parts and need some sort of control showing when parts
are runing out and need to be reordered. |
#2
|
|||
|
|||
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 "Glenn" skrev i meddelandet ... I have over 1000 small parts and need some sort of control showing when parts are runing out and need to be reordered. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
Variable control tip text | Excel Discussion (Misc queries) | |||
inventory control in excel | Excel Discussion (Misc queries) | |||
calendar control - formatting | Excel Discussion (Misc queries) | |||
Copying list-box control | Excel Discussion (Misc queries) |