Hi Adrianne,

In my opinion, there is no need for a macro ...
With conditional formatting, use Formula Is
=ISNA(Match(yourCell,yourRangeName,0))
and pick whatever format differentiator you want ...

HTH
Cheers
Carim