Conditional formatting rule

[biglb79]

Hello, is there anyone that would know how to setup a conditional formatting rule to bold any number that is in column A if it's appearing in column R?

 

[James006]

Hello,

You can use following formula for your cells in Column A:

=MATCH(A1,R:R,0)>0

Hope this will help

 

[Fluff]

You can use
=ISNUMBER(MATCH(A2,R:R,0))

 

[biglb79]

thanks so much to both of you!

 

[Fluff]

Glad we could help & thanks for the feedback