Change color on cells if match

Hi,

I´m looking for a function that look at all the columns in the sheet1 and compare it with a column in sheet2, and if it finds a match (same value) in sheet2 then I want the cell in sheet1 to be filled with color. Any ideas?

You can do that with conditional formatting, use a formula
=ISNUMBER(MATCH(B2,Sheet2!$A$2:$A$27,0))
change ranges to suit

Thanks, I changed the range but it didnt work. Can it be because of my values countains letters (A11-41)?

The letters aren't a problem. Can you supply a sample file?

Yes here you go (if the file got attached..)

To upload a workbook, Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

I did upload it under manage attachments, but then the button for attachments in relies were empty..

Ok, thanks for the file.
Select A1:I7 on sheet1 & use this formula
=ISNUMBER(MATCH(A1,Sheet2!$A$1:$A$11,0))

It worked! Thank you very much!!

Glad to help & thanks for the feedback