| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Data Valadation -
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 |
|
#2
|
|||
|
|||
|
One way:
Allow: Custom Formula: =AND(G7<"",G7<"E") uncheck the "ignore blank" checkbox. In article , "KimberlyC" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop-down list in data valadation does not work | Excel Discussion (Misc queries) | |||
| Data Valadation help | Excel Worksheet Functions | |||
| How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Linear Mode
