Forum Discussion
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 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.
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.
HansVogelaar https://docs.google.com/spreadsheets/d/1_F5rUjh1OrnUm-s5oEfdiFWLxnSuPz5H/edit?usp=drivesdk&ouid=117625516202022910541&rtpof=true&sd=true
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
You will have to share the workbook - I currently get "Access Denied".
