SOLVED

Can you put 2 data validations on a single cell in Excel?

%3CLINGO-SUB%20id%3D%22lingo-sub-3510578%22%20slang%3D%22en-US%22%3ECan%20you%20put%202%20data%20validations%20on%20a%20single%20cell%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3510578%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20do%202%20things%20with%20a%20cell%20in%20Excel%3A%3C%2FP%3E%3CP%3E1.%20Limit%20data%20entry%20to%20the%20values%200-3.%3C%2FP%3E%3CP%3E2.%20Do%20not%20allow%20data%20entry%20in%20the%20cells%20until%20the%20value%20of%20another%20cell%20%3D%2048.%3C%2FP%3E%3CP%3ECan%20I%20do%20this%20in%20Excel%3F%20It%20seems%20like%20you%20can%20only%20have%201%20data%20validation%20rule%20per%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3510578%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3510689%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20you%20put%202%20data%20validations%20on%20a%20single%20cell%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3510689%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1425233%22%20target%3D%22_blank%22%3E%40ebethfoster%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAssuming%26nbsp%3B%3CSPAN%3E%3CEM%3Eanother%20cell%3C%2FEM%3E%20is%20A1%20and%20your%20Data%20Validation%20is%20on%20B1%2C%20use%20the%20following%20Custom%20formula%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DAND(A1%3D48%2C%20B1%26gt%3B%3D0%2C%20B1%26lt%3B%3D3)%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3510945%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20you%20put%202%20data%20validations%20on%20a%20single%20cell%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3510945%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F75890%22%20target%3D%22_blank%22%3E%40L%20z.%3C%2FA%3Ethat%20did%20the%20trick!%20thank%20you%20very%20much!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3511751%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20you%20put%202%20data%20validations%20on%20a%20single%20cell%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3511751%22%20slang%3D%22en-US%22%3EGlad%20I%20could%20help.%20At%20the%20bottom%20of%20my%20previous%20reply%20there's%20a%20link%20to%20Mark%20as%20solution%20-%20something%20that%20can%20help%20those%20who%20search%20this%20site.%20Thanks%20in%20advance%3C%2FLINGO-BODY%3E
New Contributor

I need to do 2 things with a cell in Excel:

1. Limit data entry to the values 0-3.

2. Do not allow data entry in the cells until the value of another cell = 48.

Can I do this in Excel? It seems like you can only have 1 data validation rule per cell.

3 Replies
best response confirmed by ebethfoster (New Contributor)
Solution

@ebethfoster 

 

Assuming another cell is A1 and your Data Validation is on B1, use the following Custom formula:

=AND(A1=48, B1>=0, B1<=3)

@L z.that did the trick! thank you very much! 

Glad I could help. At the bottom of my previous reply there's a link to Mark as solution - something that can help those who search this site. Thanks in advance