Excel formulas/questions from an Excel newbie

Hey guys,

I made a spreadsheet that I'll be using to make some tasks easier at work, but have a question about something, since I'm not the best at working with Excel.

Basically what I've created is a spreadsheet that I can use to help take inventory, and order products for the store. I've a column of a pre-defined "build-to" or minimum of a product I want to keep on hand at all times. As I take inventory, I type how many of each item I have, and it will automatically calculate how many I need to order to reach my "build-to" requirement.

I've attached an example of the spreadsheet to this post.

Anyhow, I've got a couple of questions....

1)...Say I only have a build-to threshhold of one (1) or (1.5) on a product, since it's one we don't sell as much of. On those products I may have half of a box left, but don't want to order a full box yet, since we get shipments of goods every Tuesday and Friday.

If I have a build-to on the spreadsheet of "1.5", and say I have 3/4 of a case of a product left, the spreadsheet will output that I need to order .75 units of a product....which won't work since you can only order a full unit.

Is there any way I can make the text in the "QTY Needed" column appear as a different color or something, if it outputs a WHOLE number...meaning not fraction of a number like ".5"? This would make it easier to determine what products I need to order when I go to put the order in, without having to read through every page and column.

Or even better yet... When I do an order, I may have a few hundred different products on the order form. Is there a way to make it copy all of the rows with WHOLE NUMBER, or "1+" "QTY Needed" numbers over two a seperate spreadsheet page? That way I could just print it out, and I'd have one sheet with all the items I need to order on it, and not have to weed through all the other items on the list that I don't need to order.

And...

Second question...

Are there any cheap PDA or hand-held type devices that handle excel spreadsheets? This would enable me to load my inventory/order template onto the device, and use it to walk around and enter all of my inventory into it electronically. I can then transfer it over to the computer to print out the order list, to input my order with the distributer.

Like I said, I've used spreadsheets a little bit before, but mainly from the end-user side, with pre-made templates, where you just have to enter the data....not where you create the formulas to make the spreadsheet work.

Thanks for your help...

-Shane

Originally Posted by royUK

You can use Conditional Formatting. see

http://www.excel-it.com/excel_condit...formatting.htm

You can have 3 conditions
cell value is greater than 0
cell value is less than 0
cell value is equal to 0

Thanks for the reply. I learned something new today. That will work okay for distinguishing my numbers that I need to order, but can I take that even farther?

I've heard of data being able to be entered on one page, and it can export certain data to another page in the spreadsheet.

So is there any way I could make it take all rows that have at least a 1.0 in my "QTY Needed" column, and copy that over to another page? That way I could print that page out and have a full list of all the things I need to order.

Thanks.

-Shane