Data Validation formula problem

[Guest]

I am trying to create a data validation formula. I want it to protect from
user input that doesn’t meet the following:
• If F50 = “Close†or if F50 = “Lastâ€
And If F31<>â€â€
Then F61 needs to be > F31.
• If F50 = “Open†I don’t care what the input is.
• If F31 is blank (“â€) then there can be no input in F61 since we cannot
verify
against a value in F31.

(Note F50 is a drop down box that gives the user choices of “Openâ€, “Closeâ€
or “Last†only.)

 

[JE McGimpsey]

One way:

Allow: Custom
Formula: =AND(F31<>"",OR(F50="Open",F61>F31))