Forum Discussion

Lawrence Rosdobutko's avatar
Lawrence Rosdobutko
Copper Contributor
Nov 26, 2017

Component Tracking, and inventory

Hey all, I've been a VERY casual user of Excel for some time, and I generally make my way using tutorials and other resources online for the things I need to do. However, this time I am at a bit of a loss as to where to begin. 

I've recently been put in charge of a welding shop that creates weldments for various projects.

In a nut shell, what I would like to achieve with Excel is to create a spreadsheet that tracks completed components for a project or work order, and then highlights, or visually indicates in some way, when enough components have been completed to fully assemble the project.

For instance, if a project requires 10 components to assemble, I would like Excel to track, via user-input, when those components have been completed, and the project is ready for final assembly.

I'm simply not sure where to begin, in terms of searching. I feel like inventory cataloging is not QUITE the desired function here, but close. If I knew what sort of functionality it is I was looking for I would be able to piece together the information I needed myself, rather than having you fine people do the actual work for me!

Thanks for any help you might be able to provide!

-Lawrence.

excel

1 Reply

  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    Nov 29, 2017

    Hi Lawrence

     

    I hope I'm understanding you on this, but it sounds like you may need to use Conditional Formatting which will pick up when you hit a certain number (e.g. 10 or more) and will autmatically highlight the text (e.g. green).

     

    Sample file is attached. 

     

    If this is useful, you can find Conditional Formatting via:

    1. Highlight the cells you want to use (e.g. the cells that will have the assembled components # figure).
    2. Go to the Home tab in the ribbon menu, open Conditional Formatting.
    3. Open Highlight Cells Rules > Greater Than...
    4. Enter your desired number (e.g. 9 will mean that anything 10 and above will change colour).
    5. In the drop down list, select your desired format (e.g. Green Fill with Dark Green Text).
    6. Click OK.
    7. Type a number into one of the (conditionally formatted) cells and test the results.

    I hope that helps?

     

    Cheers

    Damien

     

Resources