Conditional Formatting when a cell's entry matches an entry in a List?

[mwscarponi]

I want an cell to be highlighted if it matches any entry in a certain list. I was thinking I could do it with a MATCH formula, but I can't get it to work. Any help would be awesome!

 

[louisH]

---

Hi.

Conditional formatting with formula :

=ISNUMBER(MATCH(YourHighlightedCell, YourList, 0))

applied to YourHighlightedCell

 

[wideboydixon]

Use a formula:

=ISNUMBER(MATCH([cell],[range],0))

[cell] is the cell that you're highlighting

#VALUE!

 

[mwscarponi]

Thanks!