Custom data validation with dropdown

[Travman1986]

Hi,
Is it possible to implement an IF statement with a dropdown list, so that the dropdown list will only appear if a certain condition is met, otherwise the cell would stay blank

The logic I am trying to achieve is =IF(M60="No", Dropdown List Appears ,"")

[dflak]

I assume we are talking about Data Validation drop-down lists?

I found out that you can do a lot of things with the name manager. I defined a named range: MyList =IF(Sheet1!$A$1="NO",Sheet1!$E$1,Sheet1!$D$2:$D$4)

If Cell A1 = "No" it points to the empty cell E1. Otherwise it points to the range D2:D4. Adjust to meet your needs.