Excel - Conditional Formatting find duplicates on two worksheets by Chris Menard

Thanks for the video, how about if it's from two different excel files? Without copying/pasting the info into one workbook?

Whenever I have an Excel problem I always search your channel. Appreciate the clear instructions. Miles better than any other instructions. Thanks Chris!

Thank you

It works great on desktop excel but not on online excel 😢. Any work arounds?

Thank you sir!

Did you just like give up on your explanation halfway through? You went from "here's how to do it" to "oh well they'll figure it out" in 10 seconds

Don't be fooled by the comments. This doesn't work

This doesn't work

Thank you sir

GOD BLESS YOU MAN. ❤

Thank you so much bro,. Good job!

Hello, i want to ask a question, may you want to answer. why it has to be rather than 0?
thank you..

How can you do the formula if its 2 columns?

Thank you, Chris. Very precise and to the point. I really Appreciate it!

I Love You thanks alot <3

Hi sir,. How to find duplicates in 3 sheets using condition formatting

waste of time it didn't work.

Thanks Chris

This was a wonderful video, thank youfor it. is there a way to have it delete the duplicate instead of highlighting it?

This video was very helpful. Thank You!

This is awesome! Thank you!

Hi Chris, my data has mulitple columns, i want to sort " Sheet 1" and " Sheet 2" to compare the data. Meaning whatever is displayed on "Sheet 1" is also duplicated on "Sheet 2".How can i accomplish this? Many thanks again. Your formula has been very helpful that i created a macro due to having to sort the same data monthly. So thank you again.

You are a life saver! Thank you for making this simple to follow video tutorial.

Thanks so much for this video. I am an Executive Assistant and this saved me a lot of time on a task a client sent me.

Thank You Chirs, You couldn't imagine how this tutorial helped me and saved my time.

Thank you so much sir. Your video easy to understand and not complicated.

That was exactly I wanted! So helpful, thank you.

How do I find duplicates on cells with a certain color and value in them ? So basically, depending on colour and the value contained in the highlighted cell while not highlighting other values?

Thanks a lot sir for making such a good video it is really help

VLOOK was not working, so was wondering how to remove the duplicate values. blessing in disguise. many thanks sir

Thank you so much for sharing. You just saved me several hours of work

Appreciate this video so much, thank you Chris! Helped me out immensely

Formula doesn't show up on excel version 2022.

you are a wizard sir

thank you so much i was comparing inventory over several locatoins
and i think this just saved me hours and hours of time

damn! I tried it and it's not working for me!!! 😞

Chris, can we do the same thing for more than 2 sheets? What's the solution?

Excellent - thanks Chris!

This did not work for me

This worked for me. Thank you!

great Chris !

This saved me so much time! Your instructions were clear and easy to follow. Thank you!

My phone it's blinking won't let me do anything

Amazing, clear and concise tutorial. Thank you!

Awesome

Thank you so much for this. I did have to watch the video twice and try the formula three times - but 10 minutes later you had saved me hours and hours of work. I really appreciate this video!

I've watched a few videos on this, wish I would have landed here first, thanks Chris!

I know this video is a couple years old, but it is still SO RELEVANT! I had two sheets with over 2000 rows of data and I needed to find like numbers by comparing both sheets. This formula WORKS!!! :) :) :) Thank you!!!

Such a helpful video when dealing with thousands of rows. Thank you :-)

Thank you.

I am doing exactly the same as you have demonstrated and am getting the "Error : you cannot use references to other worksheets or workbooks for conditional formatting criteria"