I have a form that people fill in, and there are columns across the top. Each row is another module bolted on to the final product. However, each column does not necessarily need inputs, depending on the Part type selected.
In my example, we have 2 basic part types: Mechanical and Electrical.
If a Mechanical Part is selected, I would like to grey out the fields I choose are not required (I've made it easy in this sample - no electrical variable fields needed for mech parts).
The issue I am running into is that we add new mechanical parts occasionally to our list of options on the drop down, and I would like this logic to include the new parts (so it needs to be a range). However, I don't know if that is possible as I can only think of using the OR statement in the formatting which references individual cells.
Hoping someone has a better way to do this. I'd like to avoid macros since this sheet will be sent out externally.
In a perfect world, if a mechanical part was selected, I would actually not allow inputs in the electronic variables fields, but even just greying out is fine since the background formulas will ignore those inputs anyways.
Bookmarks