Data Valadation -

  • Thread starter Thread starter KimberlyC
  • Start date Start date
K

KimberlyC

Hi

I need to set data valadation to cell H7 that will not allow data to be
entered into cell H7 if cell G7 is blank OR if cell G7 = "E".

I know how to set the data valadation if it was only limited to cell G7
being blank (thanks to the news group), but I don't know how to do it with
the new criteria I've added above.

Thanks in advance for your help..

Kimberly
 
One way:

Allow: Custom
Formula: =AND(G7<>"",G7<>"E")

uncheck the "ignore blank" checkbox.
 

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

Data Valadation 4
nested if statements using "AND" as well as "OR" 2
Simple Formula Help 4
using row number or column letters in formula 5
Drop Down List Question 5
Data Valadation help 2
No entry in cell J10 if cell J7 is empty 7
Leaving Cell Blank 2

Back
Top