How can I get a cell locked if the condition is false?

[FareedAhmed76]

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.

[Jason Morin]

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.
>
>.
>