SOLVED

Check Cells according to rows match

%3CLINGO-SUB%20id%3D%22lingo-sub-2142007%22%20slang%3D%22en-US%22%3ECheck%20Cells%20according%20to%20rows%20match%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2142007%22%20slang%3D%22en-US%22%3E%3CP%3EI%20did%20use%20conditional%20formatting%20to%20check%20which%20cells%20match%2C%20however%20I%20want%20to%20check%20if%20both%20the%20cells%20in%20the%20column%20C%20and%20U%20match%20according%20to%20row.%3C%2FP%3E%3CP%3Ei.e.%26nbsp%3B100x100%20(Beige%20Khaki)%20-%20Polypropelene%20Fabric%20(cell%20C3)%20-%20is%20in%20row%20no.%203%20and%26nbsp%3B100x100%20(Beige%20Khaki)%20-%20Polypropelene%20Fabric%20(cell%20U3)%20are%20in%20the%20same%20row.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2142007%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2142425%22%20slang%3D%22en-US%22%3ERe%3A%20Check%20Cells%20according%20to%20rows%20match%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2142425%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F953184%22%20target%3D%22_blank%22%3E%40Somersetinventory%3C%2FA%3E%26nbsp%3BPerhaps%20like%20this.%20Enter%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DC3%3DU3%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ein%20S3%20and%20copy%20it%20all%20the%20way%20down.%20TRUE%20means%20that%20the%20cells%20on%20the%20same%20row%20in%20columns%20C%20and%20U%20match%2C%20FALSE%20means%20that%20the%20don't.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I did use conditional formatting to check which cells match, however I want to check if both the cells in the column C and U match according to row.

i.e. 100x100 (Beige Khaki) - Polypropelene Fabric (cell C3) - is in row no. 3 and 100x100 (Beige Khaki) - Polypropelene Fabric (cell U3) are in the same row.

 

3 Replies
best response confirmed by Somersetinventory (Occasional Contributor)
Solution

@Somersetinventory Perhaps like this. Enter 

 

=C3=U3

 

in S3 and copy it all the way down. TRUE means that the cells on the same row in columns C and U match, FALSE means that the don't. 

Thank you so much, I was just unnecessarily complicating things. @Riny_van_Eekelen 

@Somersetinventory Glad I could help!