Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
can anyone help....
I want to use data validation to allow a drop down list in a cell but only if certain criteria are met. e.g. If A1="yes" then show yes in the validation cell, if b1="no" then show no, if not then shown the dropdown list for yes/no At the moment i have the validation in cell d1 as a list with this formula: =IF(OR(A1="",B1=""),YESNO,IF(A1="YES","YES",IF(B1= "NO","NO",YESNO)))) With the name of my list being yesno thanks for any help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Drop-Down List Choice Affects Multiple Cells? | Excel Worksheet Functions | |||
Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
add to a cell on a list based on two criteria | New Users to Excel | |||
data validation list should have opt. to select based on criteria | Excel Worksheet Functions | |||
Extract multiple records matching criteria from list | Excel Worksheet Functions |