LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default List if criteria are met

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop-Down List Choice Affects Multiple Cells? Patrick R Excel Worksheet Functions 5 November 24th 06 12:33 AM
Filter the results of a list based on a previous vlookup against the same list Mizpah Excel Worksheet Functions 2 August 18th 06 10:28 AM
add to a cell on a list based on two criteria gabrielinlompoc New Users to Excel 0 February 9th 06 10:07 PM
data validation list should have opt. to select based on criteria be Excel Worksheet Functions 1 September 15th 05 01:05 PM
Extract multiple records matching criteria from list William DeLeo Excel Worksheet Functions 12 June 30th 05 02:35 PM


All times are GMT +1. The time now is 03:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"