How to search for a bank of numbers within a workbook

[ryan_u89]

Hi,

I was wondering if there was a way to search for a bank of numbers within an excel workbook?

For example, I have a list of around 30 mobile phone numbers, I would like to be able to search an entire workbook of those numbers and highlight all results to then be reviewed manually?

Is there a way to do this with one click of a button?

Thanks

Ryan

[Glenn Kennedy]

use a formula like this to make the conditional formatting:

=ISNUMBER(MATCH(C1,$A$1:$A$4,0))