Employee Schedule Template-Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2637598%22%20slang%3D%22en-US%22%3EEmployee%20Schedule%20Template-Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2637598%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20set-up%20a%20schedule%20that%20identifies%20total%20needed%20employees.%26nbsp%3B%20I%20share%20the%20spreadsheet%20with%20my%20staff%20to%20allow%20them%20to%20set-up%20their%20own%20schedules.%26nbsp%3B%20Is%20there%20a%20formula%20to%20lock%20a%20cell%20under%20the%20column%20once%20the%20staffing%20needs%20have%20been%20met%3F%26nbsp%3B%20Example%2C%20I%20need%202%20employees%20on%20Monday%20but%203%20employees%20sign%20up.%26nbsp%3B%20Is%20there%20a%20way%20to%20lock%20the%20cell%20after%20the%202nd%20employee%20signs%20up%2C%20not%20allowing%20the%203rd%20person%20to%20sign%20up%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2637598%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2641443%22%20slang%3D%22en-US%22%3ERe%3A%20Employee%20Schedule%20Template-Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2641443%22%20slang%3D%22en-US%22%3EI%20don't%20know%20of%20a%20formula%20per%20se%2C%20but%20you%20could%20use%20conditional%20formatting%20to%20turn%20a%20cell%20red%20when%20a%20specified%20number%20has%20been%20reached.%3C%2FLINGO-BODY%3E
New Contributor

I would like to set-up a schedule that identifies total needed employees.  I share the spreadsheet with my staff to allow them to set-up their own schedules.  Is there a formula to lock a cell under the column once the staffing needs have been met?  Example, I need 2 employees on Monday but 3 employees sign up.  Is there a way to lock the cell after the 2nd employee signs up, not allowing the 3rd person to sign up?

2 Replies
I don't know of a formula per se, but you could use conditional formatting to turn a cell red when a specified number has been reached.
Thank you!