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.

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.

.