Prevent entry in a column

[Nick S]

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.

 

[bj]

Check out validation in help.

 

[Gord Dibben]

Nick

Select column B and

Data>Valdidation>Custom

=A1<>B1


Gord Dibben Excel MVP

 

[Nick S]

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