Hi
I want multiple data validation in a single cell. for example i want a custom formula to valid data in that cell at the same time i want users to put only integer number in the cell.
is there any possible way?
Thanks
Hi
I want multiple data validation in a single cell. for example i want a custom formula to valid data in that cell at the same time i want users to put only integer number in the cell.
is there any possible way?
Thanks
With data validation you need to choose one or the other
If the cell initially receives a value from a formula and you want to allow the user to overwrite with an integer THEN use 2 cells
EXAMPLE
A1 has the formula
A2 has Data Validation to control user input (integer).
The value in A1 is to be used unless a user has put a value in A2, then use A2
Use correct value in A3 and multiply it by 100
Formula:Please Login or Register to view this content.
Last edited by kev_; 06-07-2017 at 05:14 AM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Hi @Kev_
Thank you. I understand ur logic. Actually I want a single cell with double data validation. One data validation will come from a custom formula for data validation and in the same cell i wand a second data validation with integers.
Example
I went to Tab DATA\ DATA VALIDATION\custom
i put the formula =AND(G9<>"",L19<>L20)
Now the cell works fine with fractions too. but i want users to put only integers in this cell. that means i need another data validation here.
Now what can i do? Plz help.
Not possible within the same data validation
Your Data Validation should be forcing the user to input an integer
the condition =AND(G9<>"",L19<>L20) should drive the values elsewhere
You could block (via VBA) user access to the cell if condition not met
Last edited by kev_; 06-07-2017 at 08:27 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks