how can stop writting in cell if the near one is blank

  • Thread starter Thread starter frsm
  • Start date Start date
F

frsm

how can i not allow writting in a1 if b1 is blank?
i used custom validation but it wasn't right
plz help
 
Hi!

Try this:

Goto Data>Validation
Allow: Custom
Formula: =B1<>""
Uncheck Ignore blank
OK

Biff
 
Well heck!

I left out the most important part........

Select the cell you want this to be applied to, assume cell A1.

Then do:
Goto Data>Validation
Allow: Custom
Formula: =B1<>""
Uncheck Ignore blank
OK
Click to expand...

Biff
 
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

autofill cells 1
Show other cell if blank 5
somewhat complicated conditional formula 2
Excel formula, sum the value cell and if empty cell left blank 0
Averageifs - criteria is cell is not blank 1
Multiple IF Statement 2
Data Validation Removing blanks 0
Excel In Excel how can I block the contenent of a cell? 0

Back
Top