Excel: highlight cell if exists in list

Question

I want to create a conditional formatting rule where the cell will be highlighted if it also appears in a list (column A).

The values are all text (e.g "Apple", "Pear"). It has to be an exact match ("Apple Juice" shouldn't be highlighted if "Apple" is in the list). The result should be this:

Help will be greatly appreciated!

Solution

Select cell b2 in your example

Then from Home Ribbon

Conditional Formatting> New Rule > Classic > Use a formula to determine which cells to format

Then in formula enter:

=countif($A2:$A6,b2)>0

After you've done that use format paint brush on remaining b3 and b4 in your image

Comments

[JGFMK]

I see you are new to SO. It's customary SO etiquette to accept an answer if you feel it solves your problem.