Need solution for customised Data Validation for a Cell

[Optimus29]

Hi Friends,

I want to put a data validation rule on a cell.

My requirement is as follows

[Assuming that I want to apply this rule to Cell A1]

If A2 is not blank then User should get a dropdown to Select "YES" or "NO" as a value for Cell A1.

If A2 is blank A1 should be blank as well.

Can you please suggest a solution to put such a data validation?


Thanks in Advance!

 

[baitmaster]

You wouldn't be able to use the normal "Data > Validation" feature of Excel to do this

You could use a macro that uses the worksheet_change event as a trigger, or more simply, a formula that reports whether the data has been entered correctly. Formula is probably your best option here, macro would probably need lots of error handling, to cover all sorts of unexpected circumstances

 

[Optimus29]

You wouldn't be able to use the normal "Data > Validation" feature of Excel to do this

You could use a macro that uses the worksheet_change event as a trigger, or more simply, a formula that reports whether the data has been entered correctly. Formula is probably your best option here, macro would probably need lots of error handling, to cover all sorts of unexpected circumstances

Thanks Baitmaster for your response
Can you please elaborate on what formula we can put to handle this?