Forum Discussion
data validation
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
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.
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?
Betty_Dalmi That I don't know, unfortunately.
