deleting values

[frustratedPM]

I would like to delete values from column A which exist in column B. Can I use vLookup to perform function? If so what are the specific steps/syntax? I seem to be having difficulty. All values are zip code format.

 

[RSXchin]

Try condtional formatting

=countif(B:B,a1)

 

[frustratedPM]

Unfortunately this doesn't appear to be working for me. It returns all zeros. I'll keep digging.
Thanks so much for the suggestion!