excel sheet
 

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

excel sheet
 

Click on B3 and:

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

Then copy B3 to C3 thru E3
--
Gary''s Student - gsnu200846


"TJ" wrote:

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