Validating data in a cell with a formula

Giganews Newsgroups
Subject: Validating data in a cell with a formula
Posted by:  Pach (ms…
Date: 30 Oct 2003


I am trying to use Data Validation in a cell which contains a formula
but it doesn't work.

If I put a Validation test (say cell A1 must be greater than 0) and
set the validation alerts on, and then try and type a negative number
into A1 the validation works fine. IF however I put a formula in A1
like = B4 and then type -5 in B4, cell A1 then shows -5 and no
validation alert is triggered.

Does validation only work for typed in figures or can it evaluate the
result returned to a cell by a formula??

Help much appreciated and thanks in advance