data validation

%3CLINGO-SUB%20id%3D%22lingo-sub-1429214%22%20slang%3D%22en-US%22%3Edata%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1429214%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%3CBR%20%2F%3EI%20am%20preparing%20an%20error%20log%20sheet%2C%20in%20that%2C%20I%20used%20a%20custom%20data%20validation%20in%20D%20column%20%3CSPAN%20class%3D%22style-scope%20yt-formatted-string%22%3E%3DAND(%24C%243%26lt%3B%26gt%3B1%2C%24E%243%26lt%3B%26gt%3B1).%20just%20checking%20C%20column%20value%20is%20not%20equal%20to%201%20and%20E%20column%20is%20not%20equal%20to%201%20then%20it%20should%20allow%20entering%20in%20the%20D%20column.%26nbsp%3B%20It%20is%20working%20properly%20if%20I%20used%20as%20a%20formula%20but%20allowing%20to%20enter%20the%20value%20when%20I%20used%20in%20data%20validation.%3CBR%20%2F%3EPlease%20help%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1429214%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Desktop%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EShow%20and%20Tell%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETips%20and%20Tricks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1429427%22%20slang%3D%22en-US%22%3ERe%3A%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1429427%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F684571%22%20target%3D%22_blank%22%3E%40Betty_Dalmi%3C%2FA%3E%26nbsp%3BTried%20your%20DV%20formula%20and%20it%20works%20as%20it%20is%20supposed%20to.%20That%20is%2C%20if%20you%20indeed%20want%20to%20validate%20each%20entry%20in%20column%20D%20to%20the%20content%20of%20cells%20C3%20and%20E3.%20However%2C%20if%20you%20intend%20to%20validate%20each%20entry%20in%20D%20with%20the%20content%20in%20C%20and%20E%20on%20the%20same%20row%2C%20you%20need%20to%20remove%20the%20%24-signs%20in%20the%20DV%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1429449%22%20slang%3D%22en-US%22%3ERe%3A%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1429449%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%3A%20Thank%20you%20for%20your%20reply.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3Eyes%2C%20it%20should%20work.%20But%20it%20is%20not%20working%20on%20my%20laptop%20alone.%20I%20tried%20from%20my%20friend%20system%2C%20It%20works%20there.%20What%20may%20be%20the%20issue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1429500%22%20slang%3D%22en-US%22%3ERe%3A%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1429500%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F684571%22%20target%3D%22_blank%22%3E%40Betty_Dalmi%3C%2FA%3E%26nbsp%3BThat%20I%20don't%20know%2C%20unfortunately.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello Everyone,
I am preparing an error log sheet, in that, I used a custom data validation in D column =AND($C$3<>1,$E$3<>1). just checking C column value is not equal to 1 and E column is not equal to 1 then it should allow entering in the D column.  It is working properly if I used as a formula but allowing to enter the value when I used in data validation.
Please help

3 Replies
Highlighted

@Betty_Dalmi Tried your DV formula and it works as it is supposed to. That is, if you indeed want to validate each entry in column D to the content of cells C3 and E3. However, if you intend to validate each entry in D with the content in C and E on the same row, you need to remove the $-signs in the DV formula.

 

Highlighted

@Riny_van_Eekelen: Thank you for your reply.

yes, it should work. But it is not working on my laptop alone. I tried from my friend system, It works there. What may be the issue?

Highlighted

@Betty_Dalmi That I don't know, unfortunately.