Matching Data / Lookup from different sheets

Hi everyone,

I have a question about how to match up data from one sheet to another. I've attached an example of what I want to do.



Example:

Sheet1 has 15 rows and 17 columns of information (numbers) in each cell.

Sheet2 has 1 column of numbers of 75 cells of information (numbers).

What I want to know if it's possible is that every cell in sheet2 be compared with sheet1 and if a cell from sheet2 matches with a cell in sheet1 you can change the font color or background color or similar? Also the information from sheet2 will change often.


Thanks in advance,
Elegidos (Spain)