|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
12-07-2007, 09:52 PM
|
|||
|
|||
|
Dependant? Data Validation
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: Column A Column B Column C Row 1 ##,### Drop down 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. C1 - This will be a percentage calculation e.g. IF A1="High"*75% I have worked out the 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  |
|
#2
12-08-2007, 08:10 AM
|
||||
|
||||
|
__________________
oldchippy -------------   Click here >>> Top Excel links for beginners to Experts Forum Rules >>>Please don't forget to read these |
 |
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
