Validation Prob.

[Nigel Martin]

In cell D14 I wriiten the following validation code B14="C" OR B14="B" Basically an "A", "B", or "C" is generated from a VLOOKUP statement and I want the validation to code to throw up an error message if either an "A" or "B" is in cell B14. Any ideas?

[xl]

Data validation isn't volatile. It won't validate cell values generated by formulas.

[Yogi Anand]

On 2002-05-16 15:05, Nigel Martin wrote:
In cell D14 I wriiten the following validation code B14="C" OR B14="B" Basically an "A", "B", or "C" is generated from a VLOOKUP statement and I want the validation to code to throw up an error message if either an "A" or "B" is in cell B14. Any ideas?

You may consider using Conditionally Formatting cell D14, that it is flagged red if B14 equals "B" or "C"

If Conditional Formatting approach works for you, then apply the following Conditional Format to cell D14

=OR(B1="B",B14="C")
Format Paste color 'red'

Regards!


_________________
Yogi Anand
Edit: Deleted inactive web site reference from hard code signature line

[ This Message was edited by: Yogi Anand on 2003-01-19 17:02 ]

[James]

Hi,

Have you tried this with a message box?

If [B14].Value = A or If [B14].Value = B Then
MsgBox "wrong data", vbExclamation

The above was not tested

James

[Nigel Martin]

Thanks guys the conditional formating did the trick !