Conditional formatting AB3:AK9

[Ian1976]

Hi, I have a table of numbers (AB3:AK9) and also a list of numbers on "Sheet2" in Column B from B3:B39 can I highlight/format a number in the AB3:AK9 table if a number in there matches one from the list on Sheet2?

Thanks

 

[Joe4]

Select the cells AB3:AK9 on Sheet1, go to Conditional Formatting, select "New Rule", then select the "Use a formula to determine which cells to format" option and enter this formula:

=COUNTIF(Sheet2!$B$3:$B$39,AB3)>0

then select your desired formatting option and click OK.

 

[Ian1976]

Thanks that's great!

 

[Joe4]

You are welcome.
Glad I was able to help!