I need to auto-populate a range of cells if criteria that is in a separate cell isn't met

I am working on a staffing/ attrition spreadsheet and want to automate a lot of it. I am hoping to get "OPEN" to automatically appear in the range of cells below any position that doesn't meet the "Needs" number in column B of Sheet1. I need this to occur in each position (grayed out area) in columns C, E and G. The "Needs" number does change, so I would like to make the formula rely on that number and be modifiable. I hope that this isn't confusing, because it is to me.

Thank you in advance!

Adam

.
It would help if you could give a "before" and "after" version so we know what you are asking for. Just looking at your spreadsheet, as it is now, doesn't allow for a correct interpretation.

Sorry,

E6 (PROCESS TECHS) is the position. The range for that shift & position is E7:E11
B6 is the "need" for the Process Tech Position, which is currently 4
What I would like to do is get cell E10 to automatically populate "OPEN" when there are only 3 names in that range and the "need" is 4.

I hope that helps. I will need to duplicate this process a lot in order to finish the rest of the shifts and positions, but a push in the right direction would help a lot.