Change Cell Color if value is found in range

[noslenwerd]

Below is an example of what I would like to happen in the top row (B1:D1), when a value is found in the range A2:A5.

So basically in the conditional formatting of B1, I want it the formula to essentially say:

If any value from (A2:A5) is found in (B2:B5), change B1 to Green.

Hope this makes sense

 

[6StringJazzer]

Makes perfect sense

Select cells B1:D1 and apply this conditional formatting formula:

=SUM(COUNTIF($A$2:$A$5,B$2:B$5))>0