I need help in creating a macro that will compare two columns of text.
Essentially, I need this macro to look at column A and for whatever column A
is, to look in column B for an expected answer. If the answer given isn't
part of the list of variables, I need a result screen.

So if in column A I have the word 'CAR', and the acceptable variables for
'CAR' are "red", "green" and "blue", but in Column B the result is "FORD", I
need to have that line highlighted. Sorry if this doesn't make a lot of
sense, too little sleep, too much tea!

Thanks,
Jean