Excel 2007 Data Validation Custom Formula If Cell is Blank/Null
Posted on 2011-02-10
I am trying to create a data validation using the custom > formula means. If there is a better way, please advise:
Referencing Cell F4, for instance, I use the Data Validation > Allow: Custom > Formula:
Cell G3 holds a symbol (a checkmark). [I could use ü and then convert the F column to Wingdings where it would read it as a check mark. i.e., =IF(ISBLANK(F4),"","ü")].
When I click a space in F4, I receive the error message: "The value you entered is not valid. A user has restricted values that can be entered into this cell."
Is this a Circular Reference issue? If so, how may I go about solving what I want to do?
I don't have to use a checkmark if that complicates things. Just something where all a person needs to do is hit the spacebar in column F and 'something' will appear.