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

F

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA for Dependents shortcut menu 0
Show value from one cell in another cell if today falls between a date range 5
Conditional Formatting and cloring cells and date calculations 1
get a cell reference as a result of an If Function 1
Conditional formatting on 2nd cell 5
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Using icon sets with relative references 0
Conditional Formatting, Icons 1

Top