Help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dana Wiegner - 06 Dec 2006 03:30 GMT

I need to make a spreadsheet that will keep track of my inventory.

I want to be able to have a list of all my inventory with the total I have
in stock. I then want to have each cell have a formula that calculates if I
have dropped below a set min or above a set max.

Any help would be greatly appreciated

Cheers

Graham Wiegner

Reply to this Message

L. Howard Kittle - 06 Dec 2006 21:09 GMT

Take a look at Conditional Formating under Format.

Cell Value is > Is Greater than -- Is Less than > chose your format color.
You can have up to 3 conditions.

HTH
Regards,
Howard

>I need to make a spreadsheet that will keep track of my inventory.
>
[quoted text clipped - 9 lines]
>
> Graham Wiegner

Reply to this Message

Mickey Mouse - 07 Dec 2006 00:25 GMT

Yes, using conditional is good advice so take it! I'm in a similar position
and use conditional formatting to make a cell turn red when the cell qty
falls below a certain number.

Mickey

> Take a look at Conditional Formating under Format.
>
[quoted text clipped - 18 lines]
>>
>> Graham Wiegner

Reply to this Message