Flag Duplicate Cells

Originally Posted by protonLeah

=COUNTIF($B$1:$B$4,$A1) returns zero/False when A1 val not in B, otherwise: True

I stand corrected, I mis-read the Q, thought they wanted all dups flagged