Hi Gurus,

I have a problem with validation, i have 2 columns column A and column B, both have a validation list applied on them which contains 2 values YES and NO, What i need is that when some one selects YES from Column A then Column B should Display NO and should be locked for data entry. Please help me how to do it.

Warm regards,

Tahir