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