Conditional Formatting Help

[kcgojnur]

Hello -

I have a range of numbers in column N(N2:N11485) and I want to highlight these numbers if they match exactly from numbers in column P (P2:P215).

Any suggestions?

 

[Joe4]

Select the range N2:N11485, then enter the following Conditional Formatting formula:

=COUNTIF($P$2:$P$215,N2)>0

and choose your highlighting color.

 

[Tetra201]

Another CF rule to try:

=MATCH(N2,$P$2:$P$215,0)