Conditional formatting to find duplicate values and format cells meeting the criteria

Hi,

I need a macro that allows me to compare columns A and D (sample workbook attached) and find any values appearing in both columns (duplicate values). For each case meeting the criteria, I need the corresponding cell in column A (only on A), to be formatted as strikethrough. Since I'll be using this macro in sheets (and actually workbooks) named differently than the attached sample book, I need the code to be "generic" so it can be run on any worksheet.

Thanks!

Hi Richard,

I took me some time to understand your answer, and still don't think I got it right ... In any case, I appreciate it. Something I didn't mention is that both columns (including the Decimals one) will change in length on a weekly basis, so the range needs to be dynamic to take that into consideration.

I'm gonna give this more thought and see if I can make your suggestion work.

Thanks!

One way via vba.

Please Login or Register  to view this content.

Hi Jindon,

The code works as intended. Thank you so much!

I do now have an additional question, something I hadn't thought about. The referred column "DECIMALS" used in my sample sheet, is in fact a weekly changing list that I keep in a workbook on my desktop. I've been copying and pasting it for every sheet I work with in order to find the duplicate values. How can I make that comparison without having to copying/pasting it manually every time? I just learned Excel can "see" and even copy data from another book, even if it's not currently opened. The workbook path is "C:\Users\axtryo\Desktop\Labels\DECIMALS.xlsx" and the book itself has only one sheet (named "List"), where I store the list in column A. No more sheets, no other columns have data.

I hope you can help me with this!

Thanks!