Conditional Formating based on matching columns?

[ForcedLibreUser]

Hello,
I have a list of numbers in column A, names in B, and a secondary list of numbers in C. I am trying to make a conditional formatting formula that will change the text color in B If any of the corresponding numbers in A match C…

I’ve got $C$2:$C$1000=$A$2 but its not working correctly…Any ideas? Thanks in advance!

[mikekaganski]

Try COUNTIF($C$2:$C$1000;A2)>0

[ForcedLibreUser]

Thanks, COUNTIF($C$2:$C$1000;A2) worked perfectly…