| 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 |
| 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 | |||
Threaded Mode
