Conditional Data Validation

[nagovind]

In a cell i need to restrict the user input in a certain value for a cell A1

Say 0.1 to 15

The above is true if the cell value say B1 is 1

If the cell value in B1 is 5 then i need to change the data validation for cell A1 to be changed as 5.1 to 75 that is multiplied by B1 cell

Is it possible


Please advise

 

[nagovind]

Sorry .5 to 75

 

[Jai9]

Hi,


Try this.


In cell B1 put a dropdown with values 1 to 5.

I understand that the user will select one of these and depending uopn the selection the second dropdown should change.

Put values 1 to 15 in a range say D1 to D15.

In the next column put a formula =D1*$B$1


Now use this range to put a dropdown in cell A1.


I am not very good at explaining.

But hope this helps.


Jai

 

[Debraj]

Hi nagovind,


In DataValidation >> you can set the Criteria as Formula also..


Please have a look..


https://dl.dropbox.com/u/78831150/Excel/Conditional%20Data%20Validation%20%28nagovind%29.jpg


Regards,

Deb

PS:

Data Validation works only before input in the cell..

What if, data has been entered in A1 and then you change B1..

 

[Montrey]

Deb,


He could use conditional formatting to highlight the data val. cell if this occurs. to inform the user of U MESSED UP MAN!

 

[bobhc]

Good day Montrey

Would "U MESSED UP MAN!" not be used by those who can not take the time to type on a mobile phone, should it not be " excuse me but I am sure that some error has crept in to your data output"

 

[nagovind]

Thanks Jai9, Debraj Roy, Montrey


@Debraj Roy

Your excel sheet is working for me


Thanks a lot