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 |
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 |