Forum Discussion

louisebaronqe's avatar
louisebaronqe
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 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. 

excel
Formulas and Functions

6 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    May 10, 2022

    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.

    • louisebaronqe's avatar
      louisebaronqe
      Copper Contributor
      May 10, 2022

      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

Resources