Hi Folks,

I have a worksheet that has got 2 Columns, A and B. Both Columns have validation list with values "YES" and "NO", My query is that for example if on cell A10 if i choose Value "YES" from Validation drop down list then the cell B10 should automatically Show "NO" and should be locked for protection and no changes be made to cell B10. But if i select "NO" in A10 then B10 should show "YES" and now A10 should be locked.

I have been trying trying and trying but its not happening, Please help me on this.

Regards,


Tahir