Check out validation in help.
"Nick S" wrote:
I have two columns where values are entered, I want to prevent entry in
say B5 if a value is entered in A5 and so on down the columns.
Any help appreciated.
--
Nick S
------------------------------------------------------------------------
Nick S's Profile: http://www.excelforum.com/member.php...o&userid=16512
View this thread: http://www.excelforum.com/showthread...hreadid=470744