SOLVED

Highlight Duplicate from another sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-3349171%22%20slang%3D%22en-US%22%3EHighlight%20Duplicate%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3349171%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20have%20a%20spreadsheet%20to%20note%20rising%20costs%2C%20I%20need%20to%20highlight%20any%20duplicates%20from%20a%20previous%20month%20(on%20a%20different%20sheet).%20The%20formula%20would%20need%20to%20be%20over%202%20columns%20on%20both%20sheets.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20Sheet%202%20(titled%20February)%20would%20have%20cells%20highlighted%20if%20they%20are%20duplicated%20in%20Sheet%201%20(titled%20January)%20to%20show%20that%20a%20price%20rise%20has%20happened%20in%20both%20months.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%3F%20Formula%20I've%20found%20on%20other%20posts%20doesn't%20seem%20to%20work.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3349171%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3349664%22%20slang%3D%22en-US%22%3ERe%3A%20Highlight%20Duplicate%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3349664%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1108075%22%20target%3D%22_blank%22%3E%40louisebaronqe%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%20attach%20a%20sample%20workbook%20(without%20sensitive%20data)%2C%20or%20if%20that%20is%20not%20possible%2C%20make%20it%20available%20through%20OneDrive%2C%20Google%20Drive%2C%20Dropbox%20or%20similar%3F%20Thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3349839%22%20slang%3D%22en-US%22%3ERe%3A%20Highlight%20Duplicate%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3349839%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3CA%20title%3D%22Spreadsheet%22%20href%3D%22https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1_F5rUjh1OrnUm-s5oEfdiFWLxnSuPz5H%2Fedit%3Fusp%3Ddrivesdk%26amp%3Bouid%3D117625516202022910541%26amp%3Brtpof%3Dtrue%26amp%3Bsd%3Dtrue%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1_F5rUjh1OrnUm-s5oEfdiFWLxnSuPz5H%2Fedit%3Fusp%3Ddrivesdk%26amp%3Bouid%3D117625516202022910541%26amp%3Brtpof%3Dtrue%26amp%3Bsd%3Dtrue%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Hans%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20made%20a%20separate%20file%20which%20only%20has%20those%20two%20columns%20on%20and%20removed%20sensitive%20data%20from%20them.%20Hopefully%20the%20link%20works%20and%20you%20are%20able%20to%20view%20it.%20Cannot%20seem%20to%20think%20of%20another%20way%20I%20would%20be%20able%20to%20share%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ELouise%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3349906%22%20slang%3D%22en-US%22%3ERe%3A%20Highlight%20Duplicate%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3349906%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1108075%22%20target%3D%22_blank%22%3E%40louisebaronqe%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20will%20have%20to%20share%20the%20workbook%20-%20I%20currently%20get%20%22Access%20Denied%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3349942%22%20slang%3D%22en-US%22%3ERe%3A%20Highlight%20Duplicate%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3349942%22%20slang%3D%22en-US%22%3EHi%20Hans%2C%3CBR%20%2F%3E%3CBR%20%2F%3EApologies%2C%20please%20try%20the%20below%20link.%20I%20have%20updated%20the%20permissions.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1_F5rUjh1OrnUm-s5oEfdiFWLxnSuPz5H%2Fedit%3Fusp%3Ddrivesdk%26amp%3Bouid%3D117625516202022910541%26amp%3Brtpof%3Dtrue%26amp%3Bsd%3Dtrue%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1_F5rUjh1OrnUm-s5oEfdiFWLxnSuPz5H%2Fedit%3Fusp%3Ddrivesdk%26amp%3Bouid%3D117625516202022910541%26amp%3Brtpof%3Dtrue%26amp%3Bsd%3Dtrue%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3CBR%20%2F%3ELouise%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3350078%22%20slang%3D%22en-US%22%3ERe%3A%20Highlight%20Duplicate%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3350078%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1108075%22%20target%3D%22_blank%22%3E%40louisebaronqe%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%2C%20that%20worked.%3C%2FP%3E%0A%3CP%3E%26nbsp%3BHere%20is%20the%20workbook%20with%20new%20conditional%20formatting%20rules.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3350107%22%20slang%3D%22en-US%22%3ERe%3A%20Highlight%20Duplicate%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3350107%22%20slang%3D%22en-US%22%3EWonderful!!!!%20Thank%20you%20so%20much!%3C%2FLINGO-BODY%3E
Occasional Contributor

I'm have a spreadsheet to note rising costs, I need to highlight any duplicates from a previous month (on a different sheet). The formula would need to be over 2 columns on both sheets. 

 

For example, Sheet 2 (titled February) would have cells highlighted if they are duplicated in Sheet 1 (titled January) to show that a price rise has happened in both months.

 

Any help? Formula I've found on other posts doesn't seem to work. 

6 Replies

@louisebaronqe 

Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.

@Hans Vogelaar https://docs.google.com/spreadsheets/d/1_F5rUjh1OrnUm-s5oEfdiFWLxnSuPz5H/edit?usp=drivesdk&ouid=1176...

 

Hi Hans,

 

I have made a separate file which only has those two columns on and removed sensitive data from them. Hopefully the link works and you are able to view it. Cannot seem to think of another way I would be able to share it. 

 

Thanks

Louise

@louisebaronqe 

You will have to share the workbook - I currently get "Access Denied".

Hi Hans,

Apologies, please try the below link. I have updated the permissions.
https://docs.google.com/spreadsheets/d/1_F5rUjh1OrnUm-s5oEfdiFWLxnSuPz5H/edit?usp=drivesdk&ouid=1176...

Thanks
Louise
best response confirmed by Sergei Baklan (MVP)
Solution

@louisebaronqe 

Thanks, that worked.

 Here is the workbook with new conditional formatting rules.

Wonderful!!!! Thank you so much!