May 30 2020 09:05 PM
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
May 31 2020 01:25 AM
@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.
May 31 2020 01:50 AM
@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?