excel sheet

[TJ]

Hi,

Kindly assist.

I have scenario where I have 4 columns (B3, C3, D3, E3 )in the excel sheet.
I would like to stop the user once he has keyed information in any of these
cells.

thanks
TJ

 

[Gary''s Student]

Click on B3 and:

Data > Validation > Settings > Allow > Custom > =COUNTA($B$3:$E$3)<2

Then copy B3 to C3 thru E3