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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

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

SUMIF "value if false" not working 2
Excel functions 0
COMPARING TWO COLUMNS AND DISPLAYING MSGBOX 6
Excel Need Countifs Formula Help 0
Conditional Formatting and cloring cells and date calculations 1
Set non-continuous PrintArea via Function / Name 0
Conditional Formatting 1
Conditional formatting on 2nd cell 5

Back
Top