excel sheet

  • Thread starter Thread starter TJ
  • Start date Start date
T

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
 
Click on B3 and:

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

Then copy B3 to C3 thru E3
 
Back
Top