Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom Data Validation : Lock if MyCell = ""?
I am trying to use a custom data validation formula to prevent entry in a
cell if another cell is blank. If I enter: =ISBLANK($G$51) I get the opposite of what I want... Cell G51 is blank and I do not want the user to be able to enter data in the cell I am using validation on. If I enter: =(NOT(ISBLANK($G$51)) The user can enter data into the cell I am using validation on regardless of if there is data in it or not! I am using Excel 2003 SP3. Not sure what's up with this and couldn't find a similar post... I appreciate any insight! Later- Ray |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom Data Validation : Lock if MyCell = ""?
Use
=$G$51<"" and make sure you clear the "Ignore Blank" checkbox -- Regards, Peo Sjoblom "RayportingMonkey" wrote in message ... I am trying to use a custom data validation formula to prevent entry in a cell if another cell is blank. If I enter: =ISBLANK($G$51) I get the opposite of what I want... Cell G51 is blank and I do not want the user to be able to enter data in the cell I am using validation on. If I enter: =(NOT(ISBLANK($G$51)) The user can enter data into the cell I am using validation on regardless of if there is data in it or not! I am using Excel 2003 SP3. Not sure what's up with this and couldn't find a similar post... I appreciate any insight! Later- Ray |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom Data Validation : Lock if MyCell = ""?
Try this:
=LEN($G$51) Uncheck Ignore blank -- Biff Microsoft Excel MVP "RayportingMonkey" wrote in message ... I am trying to use a custom data validation formula to prevent entry in a cell if another cell is blank. If I enter: =ISBLANK($G$51) I get the opposite of what I want... Cell G51 is blank and I do not want the user to be able to enter data in the cell I am using validation on. If I enter: =(NOT(ISBLANK($G$51)) The user can enter data into the cell I am using validation on regardless of if there is data in it or not! I am using Excel 2003 SP3. Not sure what's up with this and couldn't find a similar post... I appreciate any insight! Later- Ray |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom Data Validation : Lock if MyCell = ""?
Try:-
=ISBLANK($G$51)=FALSE Regards, OssieMac "RayportingMonkey" wrote: I am trying to use a custom data validation formula to prevent entry in a cell if another cell is blank. If I enter: =ISBLANK($G$51) I get the opposite of what I want... Cell G51 is blank and I do not want the user to be able to enter data in the cell I am using validation on. If I enter: =(NOT(ISBLANK($G$51)) The user can enter data into the cell I am using validation on regardless of if there is data in it or not! I am using Excel 2003 SP3. Not sure what's up with this and couldn't find a similar post... I appreciate any insight! Later- Ray |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom Data Validation : Lock if MyCell = ""?
I should have also said to ensure that you uncheck Ignore Blank.
Regards, OssieMac "RayportingMonkey" wrote: I am trying to use a custom data validation formula to prevent entry in a cell if another cell is blank. If I enter: =ISBLANK($G$51) I get the opposite of what I want... Cell G51 is blank and I do not want the user to be able to enter data in the cell I am using validation on. If I enter: =(NOT(ISBLANK($G$51)) The user can enter data into the cell I am using validation on regardless of if there is data in it or not! I am using Excel 2003 SP3. Not sure what's up with this and couldn't find a similar post... I appreciate any insight! Later- Ray |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom Data Validation : Lock if MyCell = ""?
Thanks for the responses - It looks like the key factor was the "Ignore
Blank" checkbox - Crisis Averted... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to "lock" columns, rows and borders so new data | Excel Discussion (Misc queries) | |||
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
Data Validation with "VBA Refreshing" out of order | Excel Discussion (Misc queries) | |||
How can "data validation" be enforced in calculated cells | Excel Worksheet Functions | |||
How do I get rid of "Top 10" and "Custom" choices Autofilter? | Excel Worksheet Functions |