Validation Criteria of "Custom" fails to work

Giganews Newsgroups
Subject: Validation Criteria of "Custom" fails to work
Posted by:  0-0 Wai Wai ^-^ (..@x.com)
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:
=day(A2)-today()
OR
=J3-J1

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

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

Replies