Hi Pier

Go to excel help and enter this into the search box: "Prevent invalid data
entry in a worksheet" See if that helps.

cheers,
gt

"pierre" wrote:

hello
concerning data validation......
i have the following :

A B C
1 debit 4619 ......


what should i enter in order to say :
if A1=debit and B1=4619 allow only positive numbers in cell C1

THANKS