Search results for query: *

Ok, after trying sever options, I was able to create an appearance that does what I need. I am not sure what settings did what, but I got it on the first try. After that I was able to go in and change the color so that I have 3 different appearances to use in our IPN files. Kind Regards, Brian

The company that I work for designs outdoor equipment and we create the consumer assembly instruction steps as inventor drawings. When we create the .ipn for the component explosion, we change the colors of all the components. We use snow for all the parts not included in the step and use cadet...

Never mind, I figured it out with conditional formatting. Thanks all for looking.

Skip, The only issue I have with your solution, it removes the cell borders once the formula completes the calculation. Is there any way to stop that? I know that its easy enough to go in a put the borders back in, but when you are dealing with a BOM that has several hundred components, it would...

SkipVought, read my OP. I believe I stated my needs quite clearly. As for the pictures, the cell with the formula is selected so the formula shows in the formula bar. Just to appease the masses, I am attaching a mock BOM. In the future, I would be best, if the OP does not give you the...

I need a way for excel to pick the correct formula based on the first word in the description. Kind Regards, Brian

Here is the other formula. Kind Regards, Brianhttp://files.engineering.com/getfile.aspx?folder=2604d2db-fc0c-448a-8658-0ea9439e3e36&file=CURRENT_SET_UP_2.PNG

I don't think that is exactly what I am looking for. The attached is one of the formulas I am currently using. Kind Regards, Brianhttp://files.engineering.com/getfile.aspx?folder=46c8a25c-25f1-45db-aae3-39c01a59b2f9&file=CURRENT_SET_UP.PNG

Here is the extra qty table I have to use. Kind Regards, Brianhttp://files.engineering.com/getfile.aspx?folder=158cc1d2-788c-45a7-aa6d-5562da881d31&file=extra_qty.PNG

Hi all, I need some help. I am trying to automate a BOM creation task. We have three columns, extended qty, actual qty, and description. I also have a list of hardware that details how many extra get put in hardware bags based on a type. I would like to create a nested if statement that will add...