How to use data validation - Custom validation

Giganews Newsgroups
Subject: How to use data validation - Custom validation
Posted by:  0-0 Wai Wai ^-^ (..@x.com)
Date: Fri, 7 May 2004

[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"?

Replies