Data validation to enter specific numbers

[YasserKhalil]

Hello everyone
I have columns E:N and I need to add Data validation to ensure that in E just 1 is accepted & F just 2 is accepted and so on
I tried this custom formula in DV
=Column()-4<>E$3

But it seems not to work as expected
Thanks advanced for help

[davesexcel]

What I did was select the entire range
E4:N39
Selected data Validation
Whole number
equal to
=column()-4
then okay.

Enter something into that range, if is the incorrect number, msg will pop up.

[YasserKhalil]

That's great Mr. Daves
I need to prevent the user to enter any value if there is a value in the same row in addition to that

In other words, if there is a value 5 in I4 then no way to enter another value in the same row (E4:N4) .. Just one entry for that range and so on
Thanks a lot for help

[davesexcel]

Good question,
Obvious VBA, I am not sure how to do that with Data VAlidation.

Please Login or Register  to view this content.

[YasserKhalil]

Thanks a lot for the code
I was imagining it would be possible using Conditional Formatting
Generally, I liked your solution a lot
Thank you very much for great help

[YasserKhalil]

Thanks a lot for the code
I was imagining it would be possible using Conditional Formatting
Generally, I liked your solution a lot
Thank you very much for great help