| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell content is based on other cell value
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell content is based on other cell value
Use <data< validation
select to allow "custom" enter =IF(A2<=0,TRUE,FALSE) in the formula box enter a message in "error alert" tab assuming kilo's amount is in A2 -- Greetings from New Zealand "MIchel Khennafi" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell content is based on other cell value
Cool! Thanks for the idea.
Based on your suggestion, Bill, the formula could be made even shorter: validation criteria in A1: =ISBLANK(A2) validation criteria in A2: =ISBLANK(A1) Now either A1 or A2 accepts input. Joerg Mochikun "Bill Kuunders" wrote in message ... Use <data< validation select to allow "custom" enter =IF(A2<=0,TRUE,FALSE) in the formula box enter a message in "error alert" tab assuming kilo's amount is in A2 -- Greetings from New Zealand "MIchel Khennafi" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I change the content of one cell based on another? | Excel Discussion (Misc queries) | |||
| Change the data in one cell based on content of another. | Excel Discussion (Misc queries) | |||
| Delete Row based off cell content | Excel Discussion (Misc queries) | |||
| How do I set a cell value based on a formula in another cell? | Excel Discussion (Misc queries) | |||
| How to lookup row # based on content of another column's cell | Excel Worksheet Functions | |||
Linear Mode
