Multiple data validation in a single cell

[Miraz_Sarder]

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

[kev_]

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

Please Login or Register  to view this content.

[Miraz_Sarder]

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.

[kev_]

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