Conditional Formatting, checking a value against a list

[ZacCerrato]

Does anyone know of a function in which I could test the value inserted into a cell against a list and, if this value matched a value in the list, highlight the cell?

=FormatIf(Highlight, Value, "MyList", True)
I don't know, something like this?


I already know that I can apply conditional formatting to highlight, for instance, when there is a duplicate value in a group of cells.

 

[VoG]

Maybe

=ISNUMBER(MATCH(A1,B1,B100,0))

 

[ZacCerrato]

Yeah, that was helpful. Thank you, worked great!!!

 

[Peter_SSs]

I take it you worked out that the middle comma should have been a colon but also in Conditional Formatting you don't even need the ISNUMBER. This should work just as well:

=MATCH(A1,B1:B100,0)