Forum Discussion

Copper Contributor

May 10, 2022

Solved

Highlight Duplicate from another sheet

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 exam...

excel

Formulas and Functions

HansVogelaar
May 10, 2022
louisebaronqe

Thanks, that worked.

Here is the workbook with new conditional formatting rules.

louisebaronqe

Copper Contributor

May 10, 2022

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=117625516202022910541&rtpof=true&sd=true

Thanks
Louise

HansVogelaar

MVP

May 10, 2022

louisebaronqe

Thanks, that worked.

Here is the workbook with new conditional formatting rules.

louisebaronqe
Copper Contributor
May 10, 2022
Wonderful!!!! Thank you so much!