Component Tracking, and inventory

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