Excel 2007 comparing sheets

[jjesposito]

On Excel 2007, I need to compare two sheets. 

Is it possible to identify consistent data within sheet one and sheet two automatically? 

For example, 

Sheet one, column A, row 2: ABC Company 

Sheet two, column A, row 24: ABC Company 

Is there a way to highlight all duplicated info between the two sheets? 

[#2 · Accepted solution]

@jjesposito 

Hello! You've posted your question in the Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future.