compare row in 2 different worksheets

[sjp1989]

I have 2 worksheets in the same workbook, Sheet1 and Sheet2. Both sheets have the same number of columns, 31 columns and about 100 rows.
Both sheets have the same column values
Example:
<CODE>

colA Date
colB Prj Name
colC Proj owner
colD project status
etc... all the way to 31 columns of data

</CODE>I need to see if the rows in sheet 1 match the rows in sheet 2. The entire row, I've looked many places and all of them are matching cell to cell, I need to match the entire ROW.

For example:
Look at row 10 in sheet1 and go through all rows in sheet 2 if there is a match, do nothing. If there is not a match highlight that row in sheet1 to indicate there is no match for this in Sheet2.

 

[Latchmaker]

Place this formula in AF2 and fill down in each sheet
=CONCATENATE(A2,B2,C2,D2,E2,F2,G2,H2,I2,J2,K2,L2,M2,N2,O2,P2,Q2,R2,S2,T2,U2,V2,W2,X2,Y2,Z2,AA2,AB2,AC2,AD2,AE2)

Place this formula in AG2 of Sheet1
=IF(ISNA(VLOOKUP(AF2,Sheet2!AF:AF,1,0)),"No Match","")
then fill down

Place this formula in AG2 of Sheet2
=IF(ISNA(VLOOKUP(AF2,Sheet1!AF:AF,1,0)),"No Match","")
then fill down

It will not highlight the row but you can filter by AG2 and No Matches
This will match rows in both directions.

 

[sjp1989]

Thank yo so much! This does work
but what if I want to match it only in one direction
I only want to see on sheet 1 if there is a match for sheet 1 on sheet 2

 

[Latchmaker]

Then do not use the formula for for AG2 in Sheet 2