Preventing Blank based on another Cell

  • Thread starter Thread starter bluegrassstateworker
  • Start date Start date
B

bluegrassstateworker

I would like to validate data but cant quite get the formula right. I
have a cell (say F7) that cannot be blank if (say E7) another cell
equals a text value (say "S"). Anyone have an idea? I am stumped at
this seemingly easy task.
 
I forgot to add the valid combinations:
E7 = P and F7 = Entry: OK
E7 = P and F7 = Blank: OK
E7 = S and F7 = Entry: OK
E7 = S and F7 = Blank: INVALID
 
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

Copy condtional formatting in XL2007 for Windows 1
help with formula 4
Making formula cell blank 2
Conditional formatting based on formula cell 6
Excel formula, sum the value cell and if empty cell left blank 0
Need help with Data Validation Formula for a set of numerical andtext-based values 7
Validation based on the value in another cell 7
Show other cell if blank 5

Back
Top