The only I can think that would cause that is if you inserted this as your
formula
=COUNTIF($B:$B,$A$1)=0
if you did, remove the $'s from the A1 reference. Other than that I don't
know what you did wrong because I used your example and got the desired
results.

"doohen" wrote:

I tried your highlighting method and it ended up just highlighting the
entire column after applying. I will play around with that idea and see
if I can figure something out. Thanks so much for your input, I
appreciate the help!