Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I get a cell locked if the condition is false?
I am the user of MS office 2000, Here I am stuck with a function in Excel.
I would be grateful if helped. I want a cell locked (that specified cell shell not accept any value) if a condition is false. Example: If the value in cell (B1) is equal to the value in cell (A1) then the cell (C1) should accept a value. And if the value in cell (B1) is not equal to the value in cell (A1) then the cell (C1) should not accept any value. |
#2
|
|||
|
|||
While it does have its limitations, Validation is one
option: 1. Select C1. 2. Go to Data Validation 3. Choose "Custom" on the dropdown. In the "Formula" box put: =$A$1=$B$1 HTH Jason Atlanta, GA -----Original Message----- I am the user of MS office 2000, Here I am stuck with a function in Excel. I would be grateful if helped. I want a cell locked (that specified cell shell not accept any value) if a condition is false. Example: If the value in cell (B1) is equal to the value in cell (A1) then the cell (C1) should accept a value. And if the value in cell (B1) is not equal to the value in cell (A1) then the cell (C1) should not accept any value. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In excel, I seem to be "locked" on a cell and unable to click off. | Excel Discussion (Misc queries) | |||
How do I add a balloon message to a locked cell | Excel Discussion (Misc queries) | |||
Problem with IF condition or vector lookup? | Excel Worksheet Functions | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
GET.CELL | Excel Worksheet Functions |