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


--
tahir

Student, working on a project
------------------------------------------------------------------------
tahir's Profile: http://www.excelforum.com/member.php...fo&userid=6053
View this thread: http://www.excelforum.com/showthread...hreadid=522787