How to use data validation - Custom validation

  • Thread starter 0-0 Wai Wai ^-^
  • Start date
0

0-0 Wai Wai ^-^

[NB: I re-structure my question since people got misled from my previous one]

What I really wish to ask is:

I wish to use data validation for a particular cell. But it doesn't work if I
choose "custom" in the "allow" box.

1) In Data | Validation | Settings Tab | Validation Criteria, there is an
"Allow" Box.
2) I chose "custom", there is a formula.
3) I type in some formula, eg:
=J3 (Just Reference)
=J3-J1 (Reference-type formula)
=round(J1) (Function-type formula)

None of them can activate the validation function.
No matter I enter any number, it doesn't stop me.
What's more, even if I use formula auditing toolbar and clicked the icon -
"Circle Invalid Data", it still won't work.

Do you know why?
How to use data validation of "custom"?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation Criteria of "Custom" fails to work 11
Data Validation - Allow "" in Number Cell 15
Data Validation - Custom 7
Data Validation copy and paste bug 1
Data Validation - Again! 5
Data Validation using ISBLANK with non-contigious cells 2
custom data validation on cells with data validation values 2
Data Validation: How to create a dynamic range in column A and use itfor a drop-down list 2

Top