Inventory Control

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" <[email protected]> skrev i meddelandet
news:[email protected]...
>I have over 1000 small parts and need some sort of control showing when
>parts
> are runing out and need to be reordered.

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" <[email protected]> skrev i meddelandet
news:[email protected]...
>I have over 1000 small parts and need some sort of control showing when
>parts
> are runing out and need to be reordered.

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

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" <[email protected]> skrev i meddelandet
news:[email protected]...
>I have over 1000 small parts and need some sort of control showing when
>parts
> are runing out and need to be reordered.