Hi,

I want to do a lookup function but i don't know how to go by it. I have 2
worksheets. I need for Sheet1 to look for some records in Sheet2. If a
record on sheet one finds a matching record on Sheet2, Then the record on
Sheet1 would be colored coded in Red.

I hope I explained this correctly.