I'm trying to see which text entries in one array are listed in another
array. I have tried the =countif(array2,$d2)=0 method within conditional
formatting and it only seems to select some of the fileds some of the time
and I cant seem to understand where the problem that keeps it from only
selecting some of the correct fields. I can validate and see that it selects
some of the correct answers sometimes, but is not complete. Please help.
Thanks, Chris