Since you are only allowing two values, it seems like you need a conditional
function, not data validation.

Perhaps something like this:
B1: =IF(A1<"",IF(A1="apple","cash","credit"),"")

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"Teddy-B" wrote in message
...
Hi Everyone: Thanks for helping!

I need a validation formula that will allow input into a cell based upon
the
data in a different cell. For Example: I want excel to allow only the word
"cash" to be entered in B1 if the word "apple" is in A1. If a word other
than
"apple" is in A1, then excel will allow only the word "credit" to be
entered.

Thanks again!