Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lock a cell when a given cell contains data
I need to lock cell B1, for instance, when A1 contains data, an
vice-versa. I only want a user to have the ability to populate one o the two fields so that I can write a simple sum formula. Thanks in advance for the help -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lock a cell when a given cell contains data
Hi
one way: use data validation: - select cell B1 - enter the validation formula: =A1="" select cell A1 and enter the validation formula: =B1="" Frank I need to lock cell B1, for instance, when A1 contains data, and vice-versa. I only want a user to have the ability to populate one of the two fields so that I can write a simple sum formula. Thanks in advance for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation - cell lock | Excel Discussion (Misc queries) | |||
Lock out data entry in a cell | Excel Discussion (Misc queries) | |||
Lock the cell once enter the data | Excel Worksheet Functions | |||
Lock data in a cell a specific cell based on selection on other ce | Excel Worksheet Functions | |||
lock one cell when data in another | Excel Programming |