data validation

Copper 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

@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.