Validation Criteria of "Custom" fails to work

Giganews Newsgroups
Subject: Validation Criteria of "Custom" fails to work
Posted by:  0-0 Wai Wai ^-^ (
Date: Fri, 7 May 2004

Additional information:
- I'm using Office XP
- I'm using Windows XP


In Validation / Settings Tab / Validation Criteria / "Allow" Box / Custom:
I type in a formula as something like as follows:

Even if the cell (where validation applys) is invalid, there is no red circle
I clicked "formula auditing toolbar | Circle Invalid Data", but it still won't

Do you know why?
How to use "custom" validation criteria?