May 10 2022 01:06 AM
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.
May 10 2022 02:47 AM
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.
May 10 2022 03:17 AM
@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
May 10 2022 03:31 AM
You will have to share the workbook - I currently get "Access Denied".
May 10 2022 03:34 AM
May 10 2022 03:59 AM
SolutionMay 10 2022 03:59 AM
SolutionThanks, that worked.
Here is the workbook with new conditional formatting rules.