Prevent entry in a column

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.

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
>
>

Nick

Select column B and

Data>Valdidation>Custom

=A1<>B1


Gord Dibben Excel MVP

On Mon, 26 Sep 2005 08:40:39 -0500, Nick S
<Nick.S.1vyyuh_1127743541.9212@excelforum-nospam.com> 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.

Thanks guys, brain must be going mush in my old age