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 |
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 |
All times are GMT +1. The time now is 09:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com