Hi all

I am sure there is someone out there who knows how to do what I am hoping to achieve.

I don't know how to get a data validation (B1) to be dependant on any figure being entered into a cell to the left of it (A1).

For Example:


(A1) ##,### ¦ (B1) Drop down ¦ (C1) Calculation dependant on drop down


A1 - will have a value entered.

B1 - I would like the action of populating A1 to prompt the user to select from a list of 4 items in a dropdown list in B1, i.e. the user will not be able to continue onto next row until the selection has been made.

The drop down list will have "High" "Low" "Med" "Firm"

C1 - This will be a percentage calculation e.g. IF A1="High"*75%

High: 75%, Low: 25%, Med: 50%, Firm: 100%

I already have a working calculation formulae, I just don't know how to get the data validation (B1) to be dependant on any figure being entered into A1.

I hope my explanation is ok and that someone can help me.

Kind regards