Good afternoon.

In a spreadsheet, I allow the users to enter a weight either in Pounds or in
Kilos.

If a user enters the weight in Kilos, I would like to disable the data entry
in the cell where the weight in pounds would be entered.

What would be the trick / formula / worksheet macro to do such a thing...
The condition would be like : If the weight in Kilos is 0 then do not allow
any data entry in a specific cell.

Thanks so much for helping

Michel